Access to Tables

[AJ5]

Hello all,

As a best practice can you someone please recommend better way to document access level for each tables. Would like to know who has what level of access or if someone can share their experience or point to a documentation. 

[Community Alums]

Hi @AJ5 ,

You should use ACLs.

ACL is Access Control List. Though ACL we restrict user form Accessing various Tables and Fields of a table.

In ACL there are various kind of Operations:

1. Execute (To give access to user to execute the table)
2. Read (To give access to user to read the table only)
3. Write (To give access to user to edit the table)
4. Delete (To give access to user to Delete the table records)

and many more...

Difference between * and None:

* means giving access to all the fields of table. Eg: Read operation on Incident . * means all the fields of Incident form will be read only.

None means giving table level access. Eg: Read operation on Incident . None means User will only be able to see the table but no Fields of the table. We should 1st give table level access and then give other Access like Incident . * or Incident . Short description,  etc.

Also ACL runs on and condition means if user has specified any ROLE or CONDITION or SCRIPT in an ACL then when all 3 condition will satisfy then only ACL will run if any of the above goes false then the ACL will not run.

If we only specify a ROLE. CONDITION or SCRIPT is blank or not specified then the ACL will only check for ROLE. When it becomes true the ACL will run.

[Community Alums]

Hi @AJ5 ,

[Dr Atul G- LNG]

Hi @AJ5 

Every table create OOOTB  ACL

You can check the ACL or if you are on D.C release you can use access analyzer.