Skip to page contentSkip to chat
ServiceNow support
    • Community
      Ask questions, give advice, and connect with fellow ServiceNow professionals.
      Developer
      Build, test, and deploy applications
      Documentation
      Find detailed information about ServiceNow products, apps, features, and releases.
      Impact
      Accelerate ROI and amplify your expertise.
      Learning
      Build skills with instructor-led and online training.
      Partner
      Grow your business with promotions, news, and marketing tools
      ServiceNow
      Learn about ServiceNow products & solutions.
      Store
      Download certified apps and integrations that complement ServiceNow.
      Support
      Manage your instances, access self-help, and get technical support.
Find roles associated with tables (sys_security_acl_role) in an ACL - Support and Troubleshooting
  • >
  • Knowledge Base
  • >
  • Support and Troubleshooting (Knowledge Base)
  • >
  • Find roles associated with tables (sys_security_acl_role) in an ACL
KB0695271

Find roles associated with tables (sys_security_acl_role) in an ACL


18386 Views Last updated : Jul 22, 2025 public Copy Permalink English (Original)
  • English (Original)
  • Japanese
KB Summary by Now Assist

Issue

Sometimes it is required to find out which ACL are attached with a particular role , while enabling the debug could be an option it could also be found out using the sys_security_acl_role table, which ACLs have which role associated with them in an altogether different table. This could be fairly useful in reporting.

Resolution

The sys_security_acl_role table can help identify the ACLs which have a particular role associated with them.

For example, if it is required to find out how many ACLs have the ITIL role associated with them, searching on the table sys_security_acl_role in the role column for ITIL will return the required answer.

Related Links

Reporting can be done based on table sys_security_acl_role and it has to be noted that this will not give the data of ACLs which has blank role on the table.


The world works with ServiceNow.

Sign in for more! There's more content available only to authenticated users Sign in for more!
Did this KB article help you?
Did this KB article help you?

How would you rate your Now Support digital experience?

*

Very unsatisfied

Unsatisfied

Neutral

Satisfied

Very satisfied

Very unsatisfied

Unsatisfied

Neutral

Satisfied

Very satisfied

What can we improve? Please select all that apply.

What are we doing well? Please select all that apply.

Tell us more

*

Do you expect a response from this feedback?

  • Terms and conditions
  • Privacy statement
  • GDPR
  • Cookie policy
  • © 2025 ServiceNow. All rights reserved.