User can't read sys_audit_delete table

Sarah Bouil
Tera Expert

Hi,

 

The user is having roles but user can't read sys_audit_delete table. Below is the screenshot. What is the below error, kindly help me on it.

SarahBouil_0-1728838187569.png

 

But we dont have any specific ACL on table sys_audit_delete. I noticed there are read * ACL's. 

 

2 REPLIES 2

Aniket Chavan
Tera Sage
Tera Sage

Hello @Sarah Bouil ,

Since you mentioned seeing "read *" ACLs, could you check if these are specifically for the "sys_audit_delete" table? If yes, please review those ACLs and see if the right roles need to be assigned to allow access to this table.

 

Let me know your thoughts on this so we can move forward.

 

Please Mark Correct if this solves your query and also mark 👍Helpful if you find my response worthy based on the impact.


Regards,
Aniket

Sarah Bouil
Tera Expert

Hi, There are no ACL's on sys_audit_delete table. Below is the one of the '*' read ACL. User is having both test1 and test2 roles except admin role. This read ACL is also pass since the user contains the roles test1 and test2.

 

SarahBouil_1-1728840334838.png

 

The error is showing as Access is denied but I am not sure the error.

SarahBouil_2-1728840466617.png