Database

Create a user 1 CREATE USER MYUSER IDENTIFIED BY MYPASSWORD DEFAULT TABLESPACE USERS TEMPORARY TABLESPAE TEMP; Lock a user 1 ALTER USER MYUSER ACCOUNT LOCK; Unlock a user 1 ALTER USER MYUSER ACCOUNT UNLOCK; Drop a user 1 DROP USER MYUSER CASCADE; Get default tablespace for user 1 SELECT DEFAULT_TABLESPACE FROM DBA_USERS WHERE USERNAME = 'MYUSER'; View objects in tablespace