Column | Description |
|---|
id | Displays the row number id of the entry in the security table. |
documentIdobjectid | Displays the document Id associated to the document. This is auto-generated by CAM. |
folderId | Displays the folder Id associated to the folder. This is auto-generated by CAM. |
userIdContains the id of the object security is being applied to. For example a document, workspace, folder, team. |
extuserorgroupId | Displays the user Id associated to or groupId of the user. This is auto-generated by CAMexternal user or group. |
userNameextuserorgroupName | Displays the user name |
groupId | N/A |
groupName | N/A |
roleId | N/Aor group name of the external user or group |
extuserorgrouptype | The type or user or group. 1= group, 2= user |
roleId | The id of the role for the user in CAM |
denied | Displays if permission is denied to the user (0- allow /1-deny) |
accesspermissions | Displays the access permission code assigned to the user |
policyId | N/A |
expiryDate | Displays the security expiry date |
joinDate | Displays the security assigned date |
isLatest | Flag to indicate if the security has been recently updated and this is the latest record |
docId | N/A |
objectId | Displays the object Id associated to the object. This is auto-generated by CAM. |
objectType | Displays the object type. |
securityType | Displays the security type assigned (user/group) |
securityTypeId | Displays the security type Id associated to the security type. This is auto-generated by CAM |
securityTypeName | N/A |
accessaccesslevelidDisplays the access code associated to the user (3/2/1/0) | The id of the accesslevel. 0= no access, 1= read only, 2= read/write, 3=full access. |
accessLevel | Displays the access level assigned to the user (full access/read-write/read only/no-access) |
defaultSecurity | N/A |
runId | N/A |
subscriberId | Displays the tenant subscriber Id |
system | Displays the external system |
repositoryId | Displays the repository name |
documentDBName | Displays the database name |
writeDate | Displays |
createdDate | Displays the date the security was assigned to the user |
createdBy | N/A |
lastchangeDate | Displays the last update date |
lastchangeUserId | Displays the last change user id associated to the last change user. This is auto-generated by CAM. |
lastchangeUser | Displays the user name who last updated the security |
flag | |
docIdHash | Displays the folder Id |