Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

Check user name and password for users

SQL>  select   2        Username,         /*Username*/   3        Password          /*Encrypted password*/   4  from DBA_USERS   5  where Username in ('MCGREGOR','THUMPER','OPS$FARMER'); SQL>