Role definition notification_provider_admin

[marclindsay]

Trying to figure out what this role gives a user access to. Trying to see if there is an existing role that would allow someone to have access to the Provider Logs in our Production instance. 

[Maik Skoddow]

Hi @marclindsay 

if you go to the ACL table you will see that this role is used at table sys_notification_execution as well as at table sys_notification_execution_log to provide the role with read access

You also can go to table sys_security_acl_role to check for which ACLs (tables) that role is used.

Maik

[marclindsay]

This information is helpful, but there are a lot of ACLs associated with this role don't have time to evaluate all of the roles to see what we would be giving this person access to. Would be good if there was something written up that explains what this role allows someone to do.  Similar to how I have seen other write ups for Role Definitions.