SAM V2:Permissions

From CIDI Wiki
Jump to navigation Jump to search

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.

Back to SAM V2 Tables

Fields

The fields of the permission table are:

Field Description
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.