The permissions table is one of the administrative tables in SAM V2. It is used to specify if a user can add, delete, edit, or view records within a table.
Within SAM V2, permissions are setup per user for each table. It is possible to control if the user can add, edit, delete, or view records within the table. There is no field or record level permission in SAM V2, so if a user can view a table, they can view all records and all fields within the table.
Typically, only the SAM V2 administrator has access to modify the permissions table.
If you want to grant a user the same permissions as another user, use Copy User Permissions under the Administration menu.
The fields of the permission table are:
|can_add||Check this box if the user can add records to the table.|
|can_delete||Check this box if the user can delete records from the table.|
|can_edit||Check this box if the user can edit records in the table.|
|can_view||Check this box if the user can view records in the table.|
|last_updated||Date record was last updated.|
|table_name||The name of the database table for which permissions are being specified. Table name is required.|
|uid||Unique ID# of the record.|
|updated_by||User who last modified the record.|
|user_name||The user for whom the database table permissions are being specified. User name is required.|