dba_users « System Tables Views « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Tables Views
  3. dba_users
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
7.Check user name and password for users