How do I gain proper access to sys_audit_role table?

Ken K1
Giga Guru

‎08-10-2022 03:00 PM

On my PDI  (San Diego Patch 1), I can read the sys_audit_role table but I can not export the data or report on it.   All of the right click controls are also disabled in the interface.   I was testing this out before deploying it in production for auditing needs.   I am accessing it with the admin account and also tried to elevate to security admin, with no success.

Hopefully someone can help. Thank you in advance.

0 Helpfuls
  • 1,282 Views
2 REPLIES 2

Yousaf
Giga Sage

‎08-10-2022 03:38 PM

Hi Ken,

I just commented a security rule script and now i can aceess that table can read and write. It seems it not ok for security purposes because it will give access to all tables. you can look for specific Security rule or ACL by looking into table configurations.

find_real_file.png


find_real_file.png

 

I would suggest checkng the table configurations. and gain access with specific ACL.

EDITED : yea this one will work

find_real_file.png

Reporting : Reporting on system tables
Mark Correct or Helpful if it helps.


***Mark Correct or Helpful if it helps.***
Preview file
175 KB
Preview file
194 KB
Preview file
126 KB
0 Helpfuls

Arav
Tera Guru
Tera Guru

‎08-10-2022 03:43 PM

Hi,

System tables are not reportable by default with a few exceptions. Please check the page below for more details.

https://docs.servicenow.com/en-US/bundle/sandiego-now-intelligence/page/use/reporting/concept/c_ReportOnSystemTables.html

I am unsure why the export option isn't working. Maybe try it in a different browser.

Thanks,

Arav