Users: View Specific User Info

Description: View information on a specific Oracle user.

SELECT usr.username, usr.default_tablespace,
usr.temporary_tablespace "TMP TBS", usr.profile,
rl.granted_role, rl.admin_option, rl.default_role
 
FROM sys.dba_users usr, sys.dba_role_privs rl
 
WHERE usr.username = rl.grantee (+)
 
GROUP BY usr.username, usr.default_tablespace,
usr.temporary_tablespace, usr.profile,
rl.granted_role, rl.admin_option, rl.default_role;

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.