Check user name and password for users : dba_users « System Tables Data Dictionary « Oracle PL/SQL Tutorial






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








30.46.dba_users
30.46.1.Join dba_users and dba_tab_privs to find out user privileges
30.46.2.Union user name from sys.dba_users table
30.46.3.Join dba_users, dba_tab_privs
30.46.4.Check user name and password for users