Snippet Name: USER Information Description: Query for user information including default tablespace, temporary tablespace, and roles. Also see:» USER: connection information » USER: User Information 2 » USER idle time » 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 specific user info » USERS: view currently connected users » 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/ authentication » USERS: Creating Users » CREATE USER » Drop User example » Create User example » Create User Comment: (none) Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 10th, 2009
Description: Query for user information including default tablespace, temporary tablespace, and roles.
Also see:» USER: connection information » USER: User Information 2 » USER idle time » 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 specific user info » USERS: view currently connected users » 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/ authentication » USERS: Creating Users » CREATE USER » Drop User example » Create User example » Create User
SELECT u.username, u.default_tablespace, u.temporary_tablespace "TMP TBS", u.profile, r.granted_role, r.admin_option, r.default_role FROM sys.dba_users u, sys.dba_role_privs r WHERE u.username = r.grantee (+) GROUP BY u.username, u.default_tablespace, u.temporary_tablespace, u.profile, r.granted_role, r.admin_option, r.default_role;
