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 924 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database Concepts, 11g Release 1 (11.1)

Database Security

RolesOracle Database provides for easy and controlled privilege management through roles. Roles are … named groups of related privileges that you grant to users or other roles. See Also: \"Introduction to Roles\" information about role properties

Database Administrator's Guide, 11g Release 1 (11.1)

Distributed Database Administration

Supporting User Accounts and RolesIn a distributed database system, you must carefully plan the user accounts and roles that are … . The roles necessary to make available application privileges to distributed database application … links for the nodes in a distributed database system, determine which user accounts and roles each

Database Administrator's Guide, 11g Release 1 (11.1)

Managing User Privileges and Roles

Managing 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

Warehouse Builder Installation and Administration Guide for Windows and UNIX, 11g Release 1 (11.1)

Implementing Security in Warehouse Builder

RolesYou can assign a user to one or more roles. If you assign multiple roles with conflicting … granted to the multiple roles. For example, if you assign to the same user a role that allows … want to assign a user to a role that does not display on the Available Roles List, close the editor … , create the new role,

Providers for ASP.NET Developer's Guide, 11g Release 1 (11.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, 11g Release 1 (11.1)

Configuring Privilege and Role Authorization

Dropping Rolesusers and roles granted a dropped role are immediately changed to reflect the absence of the dropped … role privileges. All indirectly granted roles of the dropped role are also removed from affected

Database Administrator's Guide, 11g Release 1 (11.1)

Viewing Database Resource Manager Configuration and Status

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

Database Security Guide, 11g Release 1 (11.1)

Configuring Privilege and Role Authorization

About Privileges and Roleson. 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. This section describes the following general categories … privileges in detail. User

Database Security Guide, 11g Release 1 (11.1)

Configuring Privilege and Role Authorization

Granting and Revoking Rolesroles. Each role granted to a user is, at any given time, either enabled or disabled. The security … domain of a user includes the privileges of all roles currently enabled for the user and excludes the … privileges of any roles currently disabled for the user. A role granted to a role is called an … enable a role that contains

Database Security Guide, 11g Release 1 (11.1)

Configuring Privilege and Role Authorization

Specifying Default Rolesprivileges in the default roles of the user. You can set and alter a list of default roles for a … user by using the ALTER USER SQL statement. The ALTER USER statement specifies roles that are to be … enabled when a user connects to the database. The user must have been directly granted the roles with a … GRANT

Database Concepts, 11g Release 1 (11.1)

Database Security

Secure Application RolesOracle Database provides secure application roles, which are roles that can only be enabled by … authorized PL/SQL packages. This mechanism restricts the enabling of such roles to the invoking … to enable the roles. Before enabling the role, the application can perform authentication and … application roles

Database Concepts, 11g Release 1 (11.1)

Database Security

Introduction to RolesManaging and controlling privileges is made easier by using roles, which are named groups of … related privileges that you grant, as a group, to users or other roles. Within a database, each role name … must be unique, different from all user names and all other role names. Unlike schema objects, roles … on the role. Roles

Database Security Guide, 11g Release 1 (11.1)

Configuring Privilege and Role Authorization

Managing User RolesThis section contains: 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 Securing Role Privileges by Using Secure Application Roles

Database Security Guide, 11g Release 1 (11.1)

Configuring Privilege and Role Authorization

About User RolesManaging and controlling privileges is easier when you use roles, which are named groups of related … privileges that you grant as a group to users or other roles. Within a database, each role name … must be unique, different from all user names and all other role names. Unlike schema objects, roles … the role. This section contains:

Database Security Guide, 11g Release 1 (11.1)

Keeping Your Oracle Database Secure

Guidelines for Securing RolesFollow these guidelines when managing roles: Grant a role to users only if they need all 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

Database Security Guide, 11g Release 1 (11.1)

Configuring Privilege and Role Authorization

Revoking System Privileges and RolesYou can revoke system privileges and roles using the SQL statement REVOKE. Any user with the ADMIN

Database Security Guide, 11g Release 1 (11.1)

Configuring Privilege and Role Authorization

Listing Roles of the DatabaseYou can use the DBA_ROLES data dictionary view to list all roles of a database and the … authentication used for each role. For example, the following query lists all the roles in the database: SELECT

Database Security Guide, 11g Release 1 (11.1)

Configuring Privilege and Role Authorization

Granting System Privileges and RolesYou can use the GRANT SQL statement to grant system privileges and roles to users and roles. The … , accts_pay TO jward; Note: Object privileges cannot be granted along with system privileges and roles in … privileges or roles with the ADMIN OPTION. These privileges are usually reserved for a security

Warehouse Builder API and Scripting Reference, 11g Release 1 (11.1)

OMB Commands

OMBLIST ROLEScontext. Syntax parseListRole = OMBLIST ROLES ( [ \"QUOTED_STRING\" | ( OF USER \"QUOTED_STRING … \" ) ] ) Keywords And Parameters parseListRole 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 Security Guide, 11g Release 1 (11.1)

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