Snippet Name: USER: drop user Description: Drop a user with and without objects. 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: 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: Drop a user with and without objects.
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: 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
DROP USER Without Dropping Objects. DROP USER psoug1; =============================== DROP USER AND USER's Objects. DROP USER psoug1 CASCADE;