Change password.
 
ALTER USER SYS
IDENTIFIED BY "ZZ@#$pwrd";
 
========================
 
VIEW Password Hashes
 
CURRENT Password:
 
SELECT name, password
FROM USER$;
 
 
Previous Passwords (requires Profile verify FUNCTION IS active):
 
SELECT u.name, h.password, h.password_date
FROM USER$ u, user_history$ h
WHERE u.USER# = h.USER#;
 
=========================
 
 
Grant Access TO A Tablespace
 
ALTER USER psoug1
QUOTA 100K ON data1;
 
=========================
 
Revoke Access FROM A Tablespace
 
ALTER USER psoug1
QUOTA 0 ON data1;
 
 
=========================
 
LOCK An Account
 
ALTER USER psoug1 ACCOUNT LOCK;
 
=========================
 
Unlock An Account
 
ALTER USER uwclass  ACCOUNT UNLOCK;
 
=========================
 
Change Password Based ON Hash
 
SELECT  password
FROM USER$
WHERE name = 'MikeH';
 
ALTER USER MikeH IDENTIFIED BY XYZ;
 
SELECT password
FROM USER$
WHERE name = 'MikeH';
 
ALTER USER MikeH IDENTIFIED BY VALUES 'F894844C34402B67';
 
conn MikeH/pwd123