AW: Role owership in oracle

From: <>
Date: Sun, 17 May 2020 19:20:26 +0200 (CEST)
Message-ID: <>



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.  



Betreff: Role owership in oracle
Datum: 2020-05-17T18:15:18+0200
Von: "Sumit Kumar T" <> An: "Oracle L" <>      

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 ?    

-- Received on Sun May 17 2020 - 19:20:26 CEST

Original text of this message