Comandi Utente

ALTER USER <nomeutente> IDENTIFIED BY "<nuova pwd>";

ALTER USER <nomeutente> ACCOUNT LOCK;

ALTER USER <nomeutente> ACCOUNT UNLOCK;

ALTER USER <nomeutente> PASSWORD EXPIRE;

ALTER USER <nomeutente> DEFAULT TABLESPACE users TEMPORARY TABLESPACE <Temp> QUOTA 100M ON users QUOTA 0 ON <my_data>;

SELECT ACCOUNT_STATUS FROM DBA_USERS WHERE USERNAME = <Account Name>