Examining Role Table Privileges in Oracle Using role_tab_privs
Examining Role Table Privileges in Oracle Using role_tab_privs
This page delves into an Oracle SQL code snippet that investigates table privileges granted to a specific role.
SQL Code
1select owner || '.' || table_name "TABLE" 2, column_name 3, privilege 4, grantable 5from role_tab_privs 6where role …
Read MoreFind an Oracle role using the view dba_roles
This page explores an Oracle SQL code snippet that retrieves information about database roles based on user-provided search criteria.
SQL Code
1select * 2from dba_roles 3where role like '&role' 4/
Purpose:
- This code retrieves information about a specific …
Read MoreRetrieving User Role Privileges in Oracle using the view dba_role_privs
This page examines an Oracle SQL code snippet that fetches granted roles and their associated admin options for a specified user.
SQL Code
1select grantee 2, granted_role 3, admin_option 4from dba_role_privs 5where grantee like …
Read MoreList all the Oracle Users Account Information for the Oracle Database using dba_users
A detailed overview of user accounts in the Oracle database, including their status, creation date, tablespaces, and more
SQL Code
1set pages 999 lines 100 2col username format a20 3col status format a8 4col tablespace format a20 …
Read MoreLock or Unlock an Oracle User in the Database
A brief guide on locking user accounts using the
alter user <username> account lock;
command, including its purpose, key points, and best practices.Lock User
SQL Code
1alter user <username> account lock; 2/
Unlock User
SQL Code
1alter user <username> …
Read More