Role owership in oracle

From: Sumit Kumar T <dba.tyagisumit_at_gmail.com>
Date: Sun, 17 May 2020 21:44:10 +0530
Message-ID: <CAFW4NVy1Yo2uWzLvWE1u8pGKFBOvqZDLdcVziKCDgbnesuJ5vA_at_mail.gmail.com>



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 ?

--
http://www.freelists.org/webpage/oracle-l
Received on Sun May 17 2020 - 18:14:10 CEST

Original text of this message