- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-12-2017 03:20 AM
This is a part of this question
So Audit Records are visible for admins by default.
How to add right to READ for another users/roles? 'Cause now I've got a message like
Number of rows removed from this list by Security constraints
Thanks.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-12-2017 03:32 AM
Hi,
This can be done by modifying the below ACL :
Replace "instance" with your instance name in the above URL. For example have added an Role as itil to the above ACL to provide Read access to the sys_audit table for ITIl Users.
Note: As far I know it is not advisable to give access to other Users other than Admin for the Audit table as this may affect system performance.
Hope this helps.Mark the answer as correct/helpful based on impact.
Regards,
Shloke
Regards,
Shloke

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-12-2017 03:29 AM
Hi Ivan,
You have to check if there are any access controls (ACLs) created for "Audit" or on your "custom table".
If you found any then change the roles and conditions in that as per your requirement.
Regards,
Anjali
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-12-2017 03:30 AM
Hi Ivan,
You will have to create a READ ACL for the table in question here, from where the data is pulled.
Operation : read
Type : record
NAME: <Table Name> <none>
And save, then you can add the appropriate roles in the related list.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-12-2017 03:44 AM
Gyazo - ec78ae8191045e3489faa55528c5eeae.png
I can't add new record (role).
Elevate role security_admin is checked.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-12-2017 03:47 AM
Right click on the list of roles on the header , configure->list control
check the following field and save --> List edit insert row