[Oracle Database] Database user management

Create user SQL > create user soe identified by soe default tablespace soe temporary tablespace temp;User created. Query the user's default tablespace SQL > set line 200SQL > col username for a30SQL > col account_status for a20SQL > select username,account_status,created from dba_users where username = 'SOE' USERNAME ACCOUNT_STATUS CREATED---SOE OPEN 08-MAY-19 queries the user's default temporary tablespace SQL > col default_tablespace for a30SQL > col temporary_tablespace for a30SQL > select username Default_tablespace,temporary_tablespace from dba_users where username='SOE' USERNAME DEFAULT_TABLESPACE TEMPORARY_TABLESPACE-- SOE SOE TEMP modifies the user's default tablespace SQL > alter user soe default tablespace soe01 User altered. Modify the user's temporary tablespace SQL > alter user soe temporary tablespace temp01;User altered. User password expires SQL > alter user soe password expire;User altered.SQL > select username,account_status,created from dba_users where username = 'SOE' USERNAME ACCOUNT_STATUS CREATED-- SOE EXPIRED 08-MAY-19 lock user SQL > alter user soe account lock User altered.SQL > select username,account_status,created from dba_users where username = 'SOE' USERNAME ACCOUNT_STATUS CREATED-- SOE EXPIRED & LOCKED 08-MAY-19 unlock user SQL > alter user soe account unlock User altered.SQL > select username,account_status,created from dba_users where username = 'SOE' USERNAME ACCOUNT_STATUS CREATED-- SOE EXPIRED 08-MAY-19 modifies user password SQL > alter user soe identified by soe User altered.SQL > select username,account_status,created from dba_users where username = 'SOE' USERNAME ACCOUNT_STATUS CREATED-- SOE OPEN 08-MAY-19 deletes user SQL > drop user soe cascade;User dropped.