Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 10th, 2009
Change password.ALTERUSER SYS
IDENTIFIED BY"ZZ@#$pwrd";========================VIEW Password Hashes
CURRENT Password:SELECT name, password
FROMUSER$;
Previous Passwords (requires Profile verify FUNCTIONIS active):SELECT u.name, h.password, h.password_date
FROMUSER$ u, user_history$ h
WHERE u.USER# = h.USER#;=========================
Grant Access TO A Tablespace
ALTERUSER psoug1
QUOTA 100K ON data1;=========================
Revoke Access FROM A Tablespace
ALTERUSER psoug1
QUOTA 0ON data1;=========================LOCK An Account
ALTERUSER psoug1 ACCOUNT LOCK;=========================
Unlock An Account
ALTERUSER uwclass ACCOUNT UNLOCK;=========================
Change Password Based ON Hash
SELECT password
FROMUSER$
WHERE name ='MikeH';ALTERUSER MikeH IDENTIFIED BY XYZ;SELECT password
FROMUSER$
WHERE name ='MikeH';ALTERUSER MikeH IDENTIFIED BYVALUES'F894844C34402B67';
conn MikeH/pwd123