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


21 to 40 of 1106 results. previous page Prev  Next next page
Results per page:   20  | 40 | 60


Warehouse Builder OMB*Plus Command Reference, 11g Release 2 (11.2)

OMBLIST ROLES

OMBLIST ROLESPurpose To list existing roles or list existing roles whose names match the given regular expression or list the granted roles of a given user.

Database Security Guide, 11g Release 2 (11.2)

Configuring Privilege and Role Authorization

Table 4-3 Oracle Database Predefined Rolesthe DBA_SYS_PRIVS data dictionary view. Note: Oracle recommends that you design your own roles for … that you design your own roles for database security rather than relying on this role. This role may … tables SYS.INCVID, SYS.INCFIL, and SYS.INCEXP. Also the following roles: EXECUTE_CATALOG_ROLE and … DBA_SYS_PRIVS to view privileges)

Database Security Guide, 11g Release 2 (11.2)

Configuring Privilege and Role Authorization

Predefined Roles in an Oracle Database InstallationFigure 4-1 Common Uses for Roles Description of ''Figure 4-1 Common Uses for Roles'' Common Uses of … Application Roles Grant an application role all privileges necessary to run a given database … application. Then, grant the secure application role to other roles or to specific users. An application … can have

Database Security Guide, 11g Release 2 (11.2)

Managing Security for Application Developers

Associating Privileges with User Database Rolescontains: Why Users Should Only Have the Privileges of the Current Database Role Using the SET ROLE Statement to Automatically Enable or Disable Roles

Database Security Guide, 11g Release 2 (11.2)

Configuring Privilege and Role Authorization

Finding Information About User Privileges and Rolesprivileges and roles. See Oracle Database Reference for detailed information about these views.

Database Security Guide, 11g Release 2 (11.2)

Configuring Privilege and Role Authorization

Revoking Privileges and Roles from a UserThis section contains: Revoking System Privileges and Roles Revoking Object Privileges Cascading Effects of Revoking Privileges

Database Security Guide, 11g Release 2 (11.2)

Configuring Privilege and Role Authorization

Granting a User Privileges and RolesThis section contains: Granting System Privileges and Roles Granting Object Privileges Granting … Privileges on Columns It is also possible to grant roles to a user connected through a middle tier or

Database PL/SQL Language Reference, 11g Release 2 (11.2)

CREATE TRIGGER Statement

CREATE TRIGGER Statementthan acquired through roles. Syntax create_trigger::= Description of the illustration … roles or object privileges to another user or to a role. NOAUDIT Causes the database to fire the … trigger whenever a REVOKE statement removes system privileges or roles or object privileges from a

Warehouse Builder OMB*Plus Command Reference, 11g Release 2 (11.2)

OMBLIST ROLES

PrerequisitesWarehouse Builder users can be list from any context.

Warehouse Builder OMB*Plus Command Reference, 11g Release 2 (11.2)

OMBLIST ROLES

SyntaxparseListRole = OMBLIST ROLES ( [ \"QUOTED_STRING\" | ( OF USER \"QUOTED_STRING\" ) ] )

Warehouse Builder OMB*Plus Command Reference, 11g Release 2 (11.2)

OMBLIST ROLES

ParametersparseListRole This clause lists existing roles or lists existing roles whose names match the given … regular expression or lists the granted roles of a given user.

Database PL/SQL Language Reference, 11g Release 2 (11.2)

CREATE TYPE Statement

CREATE TYPE Statementowner cannot obtain these privileges through roles. If the type owner intends to grant other users

Database Security Guide, 11g Release 2 (11.2)

Configuring Privilege and Role Authorization

About Granting Roles Using the Operating System or NetworkInstead of a security administrator explicitly granting and revoking database roles to and from … roles to users at connect time. Roles can be administered using the operating system and passed to … Oracle Database when a user creates a session. As part of this mechanism, the default roles of a user … and the

Database Security Guide, 11g Release 2 (11.2)

Configuring Privilege and Role Authorization

Listing Information About the Privilege Domains of Rolesabout the privilege domains of roles. For example, the following query lists all the roles granted to

Database 2 Day DBA, 11g Release 2 (11.2)

Administering User Accounts and Security

To grant privileges and roles to the user Nick: Toward the top of the Create User or Edit User page, click Roles to display the Roles subpage. The … Roles subpage shows that the CONNECT role is assigned to Nick. Database Control automatically … .) Click Edit List. The Modify Roles page appears. Description of the illustration modify_roles.gif … In the Available

Database Security Guide, 11g Release 2 (11.2)

Configuring Privilege and Role Authorization

Table 4-2 Properties of Roles and Their Descriptionthe role. Selective availability of privileges You can selectively enable or disable the roles … awareness The data dictionary records which roles exist, so you can design applications to query … the dictionary and automatically enable (or disable) selective roles when a user attempts to execute … often create roles

Database Utilities, 11g Release 2 (11.2)

Overview of Oracle Data Pump

Required Roles for Data Pump Export and Import Operationsrole and/or the DATAPUMP_IMP_FULL_DATABASE role. These roles are automatically defined for Oracle … the names of these roles contain the word FULL, these roles are actually required for all export and … SQLFILE parameter. These roles allow users performing exports and imports to do the following … ) that unprivileged

Database Security Guide, 11g Release 2 (11.2)

Configuring Privilege and Role Authorization

Restricting SQL*Plus Users from Using Database Rolesroles and thus, prevent serious security problems. Potential Security Problems of Using Ad Hoc Tools … Limiting Roles Through the PRODUCT_USER_PROFILE Table Using Stored Procedures to Encapsulate Business … control the potential actions of a user, including the enabling and disabling of user roles while … granted to him explicitly

Database Security Guide, 11g Release 2 (11.2)

Configuring Privilege and Role Authorization

Granting and Revoking Roles When OS_ROLES Is Set to TRUEand revoking of roles to users. Any previous granting of roles to users using GRANT statements do … at the operating system level apply. Users can still grant privileges to roles and users. Note: If … the operating system grants a role to a user with the ADMIN option, then the user can grant the role only to other roles.

Database Security Guide, 11g Release 2 (11.2)

Configuring Privilege and Role Authorization

Granting Roles Using the Operating System or NetworkThis section contains: About Granting Roles Using the Operating System or Network Using Operating … System Role Identification Using Operating System Role Management Granting and Revoking Roles When … OS_ROLES Is Set to TRUE Enabling and Disabling Roles When OS_ROLES Is Set to TRUE Using Network Connections with Operating System Role