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






  1. Oracle PL / SQL
  2. System Tables Views
  3. dba_users

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>








Related examples in the same category

1.Query dba_users table
2.Displaying the Account Status of All Users
3.Verifying Resource Consumer Group Membership of Users
4.Query dba_users table for default_tablespace and temporary_tablespace
5.Join dba_users, dba_sys_privs
6.Join dba_users, dba_tab_privs