Oracle Administration User

dba_role_privs: List Oracle Roles Granted to a User Purpose Which roles does an Oracle user hold, and can that user pass them on to others? The view DBA_ROLE_PRIVS answers both questions. It describes the roles granted to all users and roles in the database. One row is one grant. The query below filters that view for …

Find 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 database role, based …

Oracle Table Privileges Granted to a Role via role_tab_privs Purpose ROLE_TAB_PRIVS lists the object privileges granted to roles — every table, view, and sequence grant, the precise privilege type, and whether the right covers the entire object or is scoped to a single column. Oracle's reference notes that "Information …

Lock or Unlock an Oracle User in the Database Purpose A contractor leaves on Friday. A service account password shows up in a chat log. A batch user fails to log in 40 times from an unknown host. In each case the first move is the same: shut the account without dropping it. ALTER USER ... ACCOUNT LOCK does that. The …

Oracle dba_users: List All User Account Information Purpose DBA_USERS is the data dictionary view that describes all users of the database. Each row is one account. The row shows the account status, the creation date, the default tablespace and the temporary tablespace. Other columns show the profile, the password …