Which role is required to query sys_audit table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-30-2023 02:36 AM
Hi Team,
Which role is required to query "sys_audit" table, other than admin role. Manager required to get ITIL user all activities so he needs sys_audit table access.
Thanks
Ashok
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-30-2023 02:49 AM
if you are using GlideRecord in some script then ACLs won't matter.
Also you can check table level READ ACL on that table and check which role is present.
why would itil user who is a fulfiller/agent require access to that table?
that table holds audit data for most of the tables and I don't think it's a good idea to expose that sensitive table data with itil users.
Please discuss this requirement with your customer. No customer would ask for this.
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader