Category: >> Oracle PL/SQL >> USERS: view specific user info Bookmark and Share

<< lastnext >>

Snippet Name: USERS: view specific user info

Description: View information on a specific Oracle user.

Also see:
» USER - connection information
» USER - User Information 2
» USER idle time
» USER Information
» USER active connected users
» USER memory use
» USER - Connected Users
» USER - drop user
» USER - misc queries and commands
» USER system authentication
» USER lock account
» USER password expiration
» USER profile
» USER tablespace quota
» USER temp tablespace
» USER tablespace
» USER password
» USERS: view currently connected us...
» USERS: view all active users
» USERS: Drop users
» USERS: Lock and Unlock accounts
» USERS: Proxy Users
» USERS: Grant tablespace access
» USERS: Alter a user
» USERS: CREATE USER w/ authenticati...
» USERS: Creating Users
» Drop User example
» Create User example
» Create User

Comment: (none)

Author: CoderZone
Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 09th, 2009

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;
There haven't been any comments added for this snippet yet. You may add one if you like.  Add a comment 
© | users online: 5