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 roles


1 to 20 of 1363 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Subprograms

Granting Roles to PL/SQL Packages and Standalone SubprogramsUsing the SQL GRANT command, you can grant roles to PL/SQL packages and standalone subprograms … . Roles granted to a PL/SQL unit do not affect compilation. They affect the privilege checking of SQL … statements that the unit issues at run time: The unit runs with the privileges of both its own roles … and any other currently

Database PL/SQL Language Reference, 12c Release 1 (12.1)

Changes in This Release for Oracle Database PL/SQL Language Reference

Can Grant Roles to PL/SQL Packages and Standalone Subprogramsuser invoked it. As of Oracle Database 12 c, you can grant roles to individual PL/SQL packages and … standalone subprograms. Instead of a DR unit, you can create an IR unit and then grant it roles. The … IR unit runs with the privileges of both the invoker and the roles, but without any additional … privileges that you have. For

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

Managing Users and Securing the Database

7.3 User Privileges and RolesPrivileges and roles are used to control user access to data and the types of SQL statements that … can be executed. The table that follows describes the three types of privileges and roles: Type … privilege that controls access to a specific object. Role A collection of privileges and other roles … . Some system-defined roles

Providers for ASP.NET Developer's Guide for Microsoft Windows, 12c Release 1 (12.1)

Oracle Providers for ASP.NET Object References

RolesThere are, at most, three types of database roles created for each provider: BasicAccess - Provides … roles created for each provider. Table 1-4 Roles and Privileges Oracle Provider Oracle Database Role

Database Security Guide, 12c Release 1 (12.1)

Configuring Privilege and Role Authorization

Dropping RolesDropping a role affects the security domains of users or roles who had been granted the role. That … is, the security domains of all users and roles that were granted to the dropped role are changed to … reflect the absence of the dropped role privileges. All indirectly granted roles of the dropped

Database Security Guide, 12c Release 1 (12.1)

Configuring Audit Policies

Auditing RolesYou can use the CREATE AUDIT POLICY statement to audit database roles. Topics: About Role Auditing

Database 2 Day DBA, 12c Release 1 (12.1)

Viewing Roles

7.4.1 Viewing RolesYou view roles on the Roles page of Oracle Enterprise Manager Database Express (EM Express). To … view roles: Log into EM Express with a user account that has privileges to manage roles. An example of … such a user account is SYSTEM. From the Security menu, select Roles. The Roles page

Database 2 Day DBA, 12c Release 1 (12.1)

Administering Roles

7.4 Administering RolesRoles are named groups of related system and object privileges. You create roles and then assign … them to users and to other roles. This section contains the following topics: Viewing Roles Example … Roles \" Oracle Database 2 Day + Security Guide for more information about administering user security,

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

Managing Resources with Oracle Database Resource Manager

27.10.1 Viewing Consumer Groups Granted to Users or RolesThe DBA_RSRC_CONSUMER_GROUP_PRIVS view displays the consumer groups granted to users or roles

Database Concepts, 12c Release 1 (12.1)

Overview of the Multitenant Architecture

Overview of Common and Local Roles in a CDBto Oracle-supplied users and roles is granted commonly, with one exception: system privileges are … granted locally to the common role PUBLIC (see \" Grants to PUBLIC in a CDB \" ). User-created roles are either local or common.

Database Concepts, 12c Release 1 (12.1)

Overview of the Multitenant Architecture

Privileges and common roles may be granted commonly.Common Roles in a CDB A common role is a database role that exists in the root and in every … existing and future PDB. Common roles are useful for cross-container operations (see \" Cross-Container … user-created or Oracle-supplied. All Oracle-supplied roles are common, such as DBA and PUBLIC. User … -created common roles

Database Concepts, 12c Release 1 (12.1)

Overview of the Multitenant Architecture

Table 18-7 Granting Roles and Privileges in a CDB… Every privilege and role granted to Oracle-supplied users and roles is granted commonly except for … to which they have access. Oracle recommends that users do not commonly grant privileges and roles … multitenant environment Grants of Privileges and Roles: Scenario In this scenario, SYSTEM creates common user … scenario

Database Security Guide, 12c Release 1 (12.1)

Configuring Privilege and Role Authorization

About Common Roles and Local RolesIn a multitenant environment, database roles can be specific to a PDB or used throughout the entire … known in all existing and future containers. All Oracle-supplied predefined roles are common roles … commonly granted privileges. Note the following: Common users can both create and grant common roles to … the

Database Security Guide, 12c Release 1 (12.1)

Configuring Privilege and Role Authorization

Managing Common Roles and Local RolesLanguage Reference for detailed information about the ALTER USER statement Managing Common Roles and … Local Roles A common role is a role that is created in the root; a local role is created in a PDB … . Topics: About Common Roles and Local Roles How Common Roles Work How the PUBLIC Role Works in a

Database Security Guide, 12c Release 1 (12.1)

Configuring Privilege and Role Authorization

Granting and Revoking RolesYou can grant privileges to roles, and then grant these roles to users or to other roles. Similarly … , you can revoke privileges from roles and users. Topics: About Granting and Revoking Roles Who Can … Grant or Revoke Roles? Granting and Revoking Roles to and from

Database Security Guide, 12c Release 1 (12.1)

Configuring Privilege and Role Authorization

About Privileges and Rolespackage, and so on. The types of privileges are defined by Oracle Database. Roles are created by … users (usually administrators) to group together privileges or other roles. They are a way to facilitate … the granting of multiple privileges or roles to users. Privileges can fall into the following … Locally Granted Privileges

Database Security Guide, 12c Release 1 (12.1)

Configuring Privilege and Role Authorization

How Common Roles WorkCommon roles are visible in every PDB in a multitenant environment. Commonly granted privileges

Database Security Guide, 12c Release 1 (12.1)

Configuring Privilege and Role Authorization

Managing User Roles… Topics: About User Roles Predefined Roles in an Oracle Database Installation Creating a Role Specifying … the Type of Role Authorization Dropping Roles Restricting SQL*Plus Users from Using Database Roles … Role Privileges and Secure Application Roles See Also: Managing Common Roles

Database Security Guide, 12c Release 1 (12.1)

Keeping Your Oracle Database Secure

Guidelines for Securing Rolesprivileges of the role. Roles (groups of privileges) are useful for quickly and easily granting permissions … to users. Although you can use Oracle-defined roles, you have more control and continuity if you … create your own roles containing only the privileges pertaining to your requirements. Oracle may … that the roles

Database Security Guide, 12c Release 1 (12.1)

Configuring Privilege and Role Authorization

About User Rolesadvantages to user management. Topics: What Are User Roles? The Functionality of Roles Properties of … Roles and Why They Are Advantageous Typical Uses of Roles How Roles Affect the Scope of a User's … Privileges How Roles Work in PL/SQL Blocks How Roles Aid or Restrict