How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
Granting Roles to PL/SQL Packages and Standalone Subprograms → Using 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
Can Grant Roles to PL/SQL Packages and Standalone Subprograms → user 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
7.3 User Privileges and Roles → Privileges 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
Roles → There 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
Dropping Roles → Dropping 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
Auditing Roles → You can use the CREATE AUDIT POLICY statement to audit database roles. Topics: About Role Auditing
7.4.1 Viewing Roles → You 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
7.4 Administering Roles → Roles 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,
27.10.1 Viewing Consumer Groups Granted to Users or Roles → The DBA_RSRC_CONSUMER_GROUP_PRIVS view displays the consumer groups granted to users or roles
Overview of Common and Local Roles in a CDB → to 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.
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
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
About Common Roles and Local Roles → In 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
Managing Common Roles and Local Roles → Language 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
Granting and Revoking Roles → You 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
About Privileges and Roles → package, 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
How Common Roles Work → Common roles are visible in every PDB in a multitenant environment. Commonly granted privileges
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
Guidelines for Securing Roles → privileges 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
About User Roles → advantages 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