Snippet Name: USER tablespace Description: Include Access To A Default Tablespace in user creation. 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 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: Highlight Mode: PLSQL Last Modified: March 09th, 2009
Description: Include Access To A Default Tablespace in user creation.
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 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 tablespace_name FROM dba_tablespaces WHERE contents NOT IN ('TEMPORARY', 'UNDO') AND tablespace_name NOT IN ( SELECT tablespace_name FROM dba_rollback_segs) AND tablespace_name NOT LIKE 'SYS%'; CREATE USER psoug1 IDENTIFIED BY password123 DEFAULT TABLESPACE data_sm; SELECT username, default_tablespace FROM dba_users ORDER BY 1;