Role owership in oracle

From: Sumit Kumar T <>
Date: Sun, 17 May 2020 21:44:10 +0530
Message-ID: <>

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 - 18:14:10 CEST

Original text of this message