List of user who have read access to table

[parth2922]

Using the name of the table, I want to fetch a list of users who have read access to that table. Does anyone have any script to fetch the users?

I have tried to fetch it using "sys_security_acl_role" but how do I identify which ACL is related to read access? I have filtered out using read operation but it gives all acls with read access. But it is not the case as every ACL with read operation has not access to the table.

[Danish Bhairag2]

Hi @parth2922 ,

U can dot walk with ACL field like sys_security_acl.operation to get the operation of the ACL.

I just tried to get the operation of the ACL in my PDI.

U can use the dot walk thing to get the relevant info.

Thanks,

Danish

[parth2922]

@Danish Bhairag2 that I am able to do. But the problem is how do I know which ACLs I need to check?

For Example:

I have fetched ACLs of an incident table with a read operation and then I have fetched the roles of those ACLs. So, I have got this below 4 roles

ml_report_user
ml_admin
itil
sn_incident_read

Here users with itil and sn_incident_read roles can read the incident table. But ml_report_user and ml_admin do not have access to an incident table. So, how check which ACL is related to table read access?