User can't read sys_audit_delete table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-13-2024 09:52 AM
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.
But we dont have any specific ACL on table sys_audit_delete. I noticed there are read * ACL's.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-13-2024 10:16 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-13-2024 10:28 AM
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.
The error is showing as Access is denied but I am not sure the error.