Hi,
Does it make a difference for the database if a role was created by User A
or User B? I think who created a role, a user, a directory, etc. is
irrelevant information for the database, so I think it is not saved
anywhere and I think that's exactly what Oracle implemented auditing for.
Regards
Ahmed
-----Original-Nachricht-----
Betreff: Role owership in oracle
Datum: 2020-05-17T18:15:18+0200
Von: "Sumit Kumar T" <dba.tyagisumit@xxxxxxxxx>
An: "Oracle L" <oracle-l@xxxxxxxxxxxxx>
Hi All,
Is there any concept of ownership of roles in oracle .
If I login from user XYZ and execute
Create role abc ;
We get an entry in dba_role_privs for grantee xyz and admin_option YES.
Now if user XYZ grant this same role to some other user with admin option
we will have 2 entries now .
Is there any way we can find out who create any given role at first place (
without audit views and we may not maintain audit data forever) .Any X$
view from oracle which capture this info ?