1
ALTER USER myuser IDENTIFIED BY new_password;

 

2

ALTER USER myuser

DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp

QUOTA 100M ON users QUOTA 0 ON my_data;

 

3
ALTER USER myuser ACCOUNT LOCK;

 

4
ALTER USER myuser ACCOUNT UNLOCK;

 

5
ALTER USER myuser PASSWORD EXPIRE;