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,
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-lReceived on Sun May 17 2020 - 18:14:10 CEST