User_privileges_1.htm
 

SELECT USERNAME, GRANTED_ROLE, DEFAULT_ROLE
FROM
USER_ROLE_PRIVS
WHERE USERNAME = 'SYSTEM'

 SELECT USERNAME, GRANTED_ROLE, DEFAULT_ROLE
FROM
USER_ROLE_PRIVS
WHERE USERNAME = 'SCOTT';

 
This user at this point did not have any tables.

SELECT USERNAME, GRANTED_ROLE, DEFAULT_ROLE
FROM
USER_ROLE_PRIVS
WHERE USERNAME = 'BABA';