Column | Description |
|---|
id | Displays the row number id of the entry in the security table. |
objectid | Contains the id of the object security is being applied to. For example a document, workspace, folder, team. |
extuserorgroupId | Displays the user Id or groupId of the external user or group. |
extuserorgroupName | Displays the user name or 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 | objectType | 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 |
accesslevelid | type. |
accesslevelid | 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 extContainerId | Id of the external system container |
repositoryIdextContainerName | 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 IdName of the external container |
metadata | Any assigned metadata to go with the security application. E.g. clientid=123 |
repositoryId | Displays the repository name |
createddate | The date the security was created |
editedDate | The date edited |
createdbyUserid | The user id of the user who created the security |
createdbyuser | The user who created the security |
lastchangeuserid | The userid of the user that last changed the record |
lastchangeuser | The user that last changed the record |
camcreateddate | The date cam had created the security |
camcreatedby | The person in cam that created |
camediteddate | The date last edited in CAM |
cameditedby | The person that last edited in CAM |
subscriberId | Displays the tenant subscriber Id |
extsystemid | Displays the external systemid |
docIdHash | Displays the hash from the table |