Datacentre Support Reference Guides

Visit our online shop for ALL your parts, components, laptops, electronics and gadgets
 

User attribute dba_ views

 
 
 
  1. dba_profiles
  2. dba_role_privs
  3. dba_roles
  4. dba_sys_privs
  5. dba_tab_privs
  6. dba_ts_quotas
  7. dba_users
dba_profiles dba_role_privs
Displays all profiles and their limits Displays the roles granted to users and roles
Name Null? Type Name Null? Type
PROFILE N VARCHAR2(30) GRANTEE Y VARCHAR2(30)
RESOURCE_NAME N VARCHAR2(32) GRANTED_ROLE N VARCHAR2(30)
RESOURCE_TYPE Y VARCHAR2(8) ADMIN_OPTION Y VARCHAR2(3)
LIMIT Y VARCHAR2(40) DEFAULT_ROLE Y VARCHAR2(3)
dba_roles dba_sys_privs
Displays all roles that exist in the database. Displays the system privileges granted to users and roles
Name Null? Type Name Null? Type
ROLE N VARCHAR2(30) GRANTEE N VARCHAR2(30)
PASSWORD_REQUIRED Y VARCHAR2(8) PRIVILEGE N VARCHAR2(40)
ADMIN_OPTION Y VARCHAR2(3)
dba_tab_privs dba_ts_quotas
Displays all grants on objects in the database. Displays tablespace quotas & current usage for all users.
Name Null? Type Name Null? Type
GRANTEE N VARCHAR2(30) TABLESPACE_NAME N VARCHAR2(30)
OWNER N VARCHAR2(30) USERNAME N VARCHAR2(30)
TABLE_NAME N VARCHAR2(30) BYTES Y NUMBER
GRANTOR N VARCHAR2(30) MAX_BYTES Y NUMBER
PRIVILEGE N VARCHAR2(40) BLOCKS N NUMBER
GRANTABLE Y VARCHAR2(3) MAX_BLOCKS Y NUMBER
dba_users
Displays information about all users of the database
Name Null? Type
USERNAME N VARCHAR2(30)
USER_ID N NUMBER
PASSWORD Y VARCHAR2(30)
ACCOUNT_STATUS N VARCHAR2(32)
LOCK_DATE Y DATE
EXPIRY_DATE Y DATE
DEFAULT_TABLESPACE N VARCHAR2(30)
TEMPORARY_TABLESPACE N VARCHAR2(30)
CREATED N DATE
PROFILE N VARCHAR2(30)
INITIAL_RSRC_CONSUMER_GROUP Y VARCHAR2(30)
EXTERNAL_NAME Y VARCHAR2(4000)