Get the list of ACLs created in the system along with the role mapping

khushnan · ‎07-14-2017

For my application , I want to get the list of ACLs created in my system , along with the role mapping.

How can I get this information? Is there any API available to fetch the list of ACLs ?

Thanks in advance

Harsh Vardhan · ‎07-15-2017

it should be because you have given security_admin role already. i am not sure why this table is not accessible in the REST API Explorer. but you can try with "security_acl_detail" . it will also give you the same result.

by the way check with thread below.

I'm trying to create an access role record using serivcenow REST API. The response code is 201 but t...

just try with soap web services . pass the below wsdl url in end point.

https://<your instance>.service-now.com/sys_security_acl.do?wsdl

by using get or getRecords check if you are able to get the records or not.

From the left navigation pane, select System Definition > Tables and Columns. Click tables

Name has all the tables/views. You can check with schema map also there.

View solution in original post

antin_s · ‎07-16-2017

Hi Khushboo,

Will be happy to help. What do you mean by ACL metadata?

Thanks

Antin

khushnan · ‎07-16-2017

I meant schema. What all are the required attributes that my application needs to fetch to create ACL entity , which is the attribute in ACL schema that contains info about the role that is assigned to an ACL.

Harsh Vardhan · ‎07-16-2017

I have assumed you are using "security_acl_detail" table to fetch the record.

if you see the column in "selected" slush bucket that mainly full fill your requirement. hope it will help you

antin_s · ‎07-16-2017

Hi Khushboo,

The following link would be able to give you what are the attributes for an ACL entry.

Create an ACL rule

Requires role (sys_security_acl_role) table needs only the following attributes

sys_security_acl (acl sys_id)

sys_user_role (role sys_id)

sys_scope (scope id or global)

Thanks

Antin

Hope this helps. Mark the answer as correct/helpful based on impact.

khushnan · ‎07-17-2017

Thanks all for your responses. Helped me alot