Is it possible to determine what user created another user's account in Oracle database?
I have two types of users in database:
- Users having system and object privileges
- Users having only system privileges
I can find the owner of all users having system and object privileges.
select distinct d.username,d.account_status,t.privilege,t.owner from dba_users d,dba_tab_privs t where d.username=t.grantee and d.account_status='OPEN';
But this query doesn't fetch the users having only system Privileges. Please help how to find the owner of all those users having only system privileges?