Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

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> SQL> SQL>