You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for DBA_ROLES


1 to 19 of 19 results.


Database Reference, 12c Release 1 (12.1)

DBA_ROLES

5.256 DBA_ROLESDBA_ROLES describes all roles in the database. Column Datatype NULL Description ROLE VARCHAR2(128

Database Security Guide, 12c Release 1 (12.1)

Configuring Privilege and Role Authorization

Query to List Roles of the DatabaseThe DBA_ROLES data dictionary view lists all roles of a database and the authentication used for … each role. For example: SELECT * FROM DBA_ROLES; ROLE PASSWORD ---------------- -------- CONNECT NO … RESOURCE NO DBA NO SECURITY_ADMIN YES See Also: Oracle Database Reference for detailed information about the DBA_ROLES view

Database Security Guide, 12c Release 1 (12.1)

Configuring Privilege and Role Authorization

Rules for Creating Local Rolesuse the same name for local roles in different PDBs. To find the names of existing roles, query the CDB_ROLES and DBA_ROLES data dictionary views.

Database Security Guide, 12c Release 1 (12.1)

Configuring Audit Policies

Oracle Database provides a set of predefined roles to help in database administration.DBA_ROLES data dictionary view. To find if the privileges granted to the role were commonly granted

Database Security Guide, 12c Release 1 (12.1)

Configuring Authentication

User Authentication Data Dictionary ViewsDBA_ROLES Displays the kind of authentication used for a database role to log in to the database, such

Database Security Guide, 12c Release 1 (12.1)

Configuring Privilege and Role Authorization

About ANY Privileges and the PUBLIC Roleuser accounts assume the PUBLIC role, it does not appear in the DBA_ROLES and SESSION_ROLES data

Database Security Guide, 12c Release 1 (12.1)

Configuring Privilege and Role Authorization

Data Dictionary Views to Find Information about Privilege and Role Grantsdifferent user's privileges DBA_TAB_PRIVS Lists all grants on all objects in the database DBA_ROLES

Database Security Guide, 12c Release 1 (12.1)

Glossary

PUBLIC rolerole. Because all database user accounts assume the PUBLIC role, it does not appear in the DBA_ROLES and SESSION_ROLES data dictionary views.

Database Security Guide, 12c Release 1 (12.1)

Configuring Authentication

Ensuring Against Password Security Threats by Using the 12C Password VersionPASSWORD_REQUIRED and AUTHENTICATION_TYPE columns of the DBA_ROLES data dictionary view to find any

Database Security Guide, 12c Release 1 (12.1)

Keeping Your Oracle Database Secure

Guidelines for Securing User Accounts and Privileges* DBA_ROLES DBA_SYS_PRIVS DBA_ROLE_PRIVS DBA_TAB_PRIVS DBA_AUDIT_TRAIL (if standard auditing is

Database Security Guide, 12c Release 1 (12.1)

Configuring Privilege and Role Authorization

Predefined Roles in an Oracle Database InstallationDBA_ROLES data dictionary view. If the output for ORACLE_MAINTAINED is Y, then you must not modify

Database Reference, 12c Release 1 (12.1)

Database Reference - Contents

ContentsDBA_ROLES 5.257 DBA_ROLLBACK_SEGS 5.258 DBA_ROLLING_DATABASES 5.259 DBA_ROLLING_EVENTS 5.260

Database Vault Administrator's Guide, 12c Release 1 (12.1)

Oracle Database Vault Reports

Tables/Views A-O Tables/Views P-S$ SOURCE$ DBA_ROLE_PRIVS STATS$SQLTEXT DBA_ROLES STATS$SQL_SUMMARY DBA_TAB_PRIVS STREAMS$_PRIVILEGED_USER

Database Real Application Security Administrator's and Developer's Guide, 12c Release 1 (12.1)

Configuring Application Users and Application Roles

Granting a Database Role to an Application Rolelisting of existing database roles by querying the DBA_ROLES data dictionary view. Example 2-14 shows how

Database Vault Administrator's Guide, 12c Release 1 (12.1)

Oracle Database Vault Secure Application Role APIs

17 Oracle Database Vault Secure Application Role APIsexisting roles in the database, query the DBA_ROLES data dictionary view, described in Oracle

Database Vault Administrator's Guide, 12c Release 1 (12.1)

Performing Privilege Analysis to Find Privilege Use

You can enable a privilege analysis policy using either Enterprise Manager Cloud Control or from SQL*Plus,…DBA_ROLES data dictionary view.) For multiple roles, use varray type role_name_list to enter the role

Database Vault Administrator's Guide, 12c Release 1 (12.1)

Oracle Database Vault Realm APIs

13 Oracle Database Vault Realm APIscurrent database instance, query the DBA_USERS and DBA_ROLES views, described in Oracle Database … or role name. To find the available users and roles, query the DBA_USERS and DBA_ROLES views

Database Vault Administrator's Guide, 12c Release 1 (12.1)

Oracle Database Vault Utility APIs

19 Oracle Database Vault Utility APIsOracle Database Reference. DBA_ROLES: Finds available roles in the current database instance. See … find existing roles, query the following views: DBA_ROLES: Finds available roles in the current … p_role Role to check. To find existing roles, query the following views: DBA_ROLES: Finds available

Database Vault Administrator's Guide, 12c Release 1 (12.1)

Oracle Database Vault Factor APIs

16 Oracle Database Vault Factor APIsfind existing roles, use the following data dictionary views: DBA_ROLES: Finds available roles in … => 'Check ISO Abbreviated Language Name', rule_expr => 'DVF.F$LANG IN (''EN'', ''DE'', ''FR'')'); END