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 privileges


41 to 80 of 2781 results. previous page Prev  Next next page
Results per page:  20 |  40  | 60


Database Performance Tuning Guide, 11g Release 1 (11.1)

SQL Access Advisor

18.2.2 Privileges Needed to Use the SQL Access Advisorthe statement's original user. If that user does not have SELECT privileges to a particular table … current database user must have SELECT privileges on the tables targeted for materialized view analysis … . For those tables, these SELECT privileges cannot be obtained through a role. Additionally, you must

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Managing a Recovery Catalog

Revoking Privileges from a Virtual Private Catalog Ownercatalog, you have granted the vpc1 user access privileges to prod1. You have also granted this user the … right to register databases in his virtual private catalog. Now you want to revoke privileges from … vpc1. To revoke privileges from a virtual private catalog owner: Start RMAN and connect to the … @catdb; Revoke specified

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Managing a Recovery Catalog

Creating and Granting Privileges to a Virtual Private Catalog Owneraccess privileges only to prod1 and prod2. By default, a virtual private catalog owner has no access to … the base recovery catalog. To create and grant privileges to a virtual private catalog owner: Start … SQL*Plus and connect to the recovery catalog database with administrator privileges. If the user … recovery catalog database

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

Granting and Revoking System PrivilegesYou can grant or revoke system privileges to users and roles. If you grant system privileges to … roles, then you can use the roles to exercise system privileges. For example, roles permit privilegesprivileges to or from users and roles: GRANT and REVOKE SQL statements Oracle Enterprise Manager

Database Data Warehousing Guide, 11g Release 1 (11.1)

Basic Query Rewrite

Privileges for Enabling Query RewriteUse of a materialized view is based not on privileges the user has on that materialized view, but … on the privileges the user has on detail tables or views in the query. The system privilege GRANT … tables and views outside your schema. The privileges for using materialized views for query rewrite

Database Security Guide, 11g Release 1 (11.1)

Configuring Privilege and Role Authorization

Cascading Effects of Revoking Privileges… This is discussed in the following sections: Cascading Effects When Revoking System Privileges … Cascading Effects When Revoking Object Privileges Cascading Effects When Revoking System Privileges There … successfully until the privilege is reauthorized. Cascading Effects When Revoking Object Privileges Revoking

Database Security Guide, 11g Release 1 (11.1)

Configuring Privilege and Role Authorization

Who Should Be Granted Privileges?You grant privileges to users so they can accomplish tasks required for their jobs. You should … granting of unnecessary privileges can compromise security. For example, you never should grant … privilege in two ways: You can grant privileges to users explicitly. For example, you can explicitly … privileges to

Database Security Guide, 11g Release 1 (11.1)

Configuring Privilege and Role Authorization

Granting Administrative Privileges to UsersAs with all powerful privileges, only grant administrative privileges to trusted users. However, be … umlaut in the name HÜBER ). You can grant administrative privileges to these users, but if the

Database Security Guide, 11g Release 1 (11.1)

Configuring Privilege and Role Authorization

Granting or Revoking Object PrivilegesEach type of object has different privileges associated with it. You can specify ALL [ PRIVILEGES … ] to grant or revoke all available object privileges for an object. ALL is not a privilege; rather … , it is a shortcut, or a way of granting or revoking all object privileges with one GRANT and REVOKE … statement.

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 … following privileges are required: To grant a system privilege, a user must be granted the system … , accts_pay TO jward; Note: Object privileges cannot be granted along with system privileges and roles in … all

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

Implementing Security in Warehouse Builder

System PrivilegesObject Privileges Object privileges apply to all metadata objects in the repository including … projects, modules, and collections. FULL CONTROL Full control includes all the other privileges plus the … ability to grant and revoke privileges on an object. Only users with full control over an object can … Properties

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

Getting Started with Oracle Label Security

Label PrivilegesCHAR(2) You will apply the following labels: Label Privileges CONFIDENTIAL Read access to the cities

Database Security Guide, 11g Release 1 (11.1)

Configuring Privilege and Role Authorization

About ANY Privileges and the PUBLIC RoleSystem privileges that use the ANY keyword enable you to set privileges for an entire category of … ( JONES ). If JONES has DBA privileges, letting JSMITH run a procedure as JONES could pose a security … when the account is created. By default, it has no privileges granted to it, but it does have numerous … dictionary

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

Database Security Guide, 11g Release 1 (11.1)

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 1 (11.1)

Keeping Your Oracle Database Secure

Guidelines for Securing User Accounts and PrivilegesFollow these guidelines to secure user accounts and privileges: Practice the principle of least … privilege. Oracle recommends the following guidelines: Grant necessary privileges only. Do not provide … database users or roles more privileges than are necessary. (If possible, grant privileges to roles … privileges

Database Security Guide, 11g Release 1 (11.1)

Managing Security for Application Developers

Managing Object Privileges in an Application… You must categorize these users into role groups, and then determine the privileges that must be … granted to each role. This section contains: What Application Developers Need to Know About Object Privileges SQL Statements Permitted by Object Privileges

Database Security Guide, 11g Release 1 (11.1)

Configuring Privilege and Role Authorization

Table 4-5 Privileges for Object Tablestable DELETE Delete rows Similar table privileges and column privileges apply to column objects … , however, does not involve named types, so Oracle Database does not check type privileges. In addition … statements, user3 does not have explicit privileges on the underlying types, but the statement succeeds … because

Database Security Guide, 11g Release 1 (11.1)

Managing Security for Application Developers

SQL Statements Permitted by Object Privilegesthat each user is assigned the proper roles. Table 5-3 lists the SQL statements permitted by the object privileges shown in Table 5-2.

Database Installation Guide for Microsoft Windows, 11g Release 1 (11.1)

Getting Started with Oracle Database

5.2.1 Understanding Database Control Login Privilegesgranted the roles and privileges required to access all the management functionality provided with … , you can grant login privileges to other database users. To grant management access for other … properties page, click Finish. Enterprise Manager assigns login privileges to the specified user and includes

Database Security Guide, 11g Release 1 (11.1)

Configuring Privilege and Role Authorization

Listing Object Privileges Granted to a UserThe following query returns all object privileges (not including column-specific privileges … NO To list all the column-specific privileges that have been granted, use the following query

Database Security Guide, 11g Release 1 (11.1)

Managing Security for Application Developers

Associating Privileges with User Database RolesEnsure that users have only the privileges associated with the current database role. This section … contains: 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 1 (11.1)

Configuring Privilege and Role Authorization

Who Can Grant or Revoke System Privileges?Only two types of users can grant system privileges to other users or revoke those privileges from … privilege GRANT ANY PRIVILEGE For this reason, only grant these privileges to trusted users.

Database Security Guide, 11g Release 1 (11.1)

Configuring Privilege and Role Authorization

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

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

Understanding Access Controls and Privileges

3.5.4 System Privileges, Object Privileges, and Policy PrivilegesRemember that Oracle Label Security privileges are different from the standard Oracle Database … system and object privileges. Table 3-4 Types of Privilege Source Privileges Definition Oracle Database … System Privileges The right to run a particular type of SQL statement   Object Privileges The right

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

Understanding Access Controls and Privileges

3.3.1 Authorizations Set by the Administrator: Chapter 8, \"Administering User Labels and Privileges\" for instructions on setting the

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

Understanding Access Controls and Privileges

3.3.2 Computed Session LabelsOracle Label Security automatically computes a number of labels based on the value of the session label. These include: Table 3-2 Computed Session Labels Computed Label Definition Maximum Read Label The user's maximum level combined with any combination of compartments and groups for which the user is authorized. Maximum Write Label The user's maximum level combined with the compartments and groups

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

Understanding Access Controls and Privileges

3.5.2 Special Access PrivilegesA user's authorizations can be modified with any of four privileges: READ FULL COMPACCESS … privilege allows a session to change its session labels and session privileges to those of a different … privileges. This privilege cannot be granted to a trusted stored program unit.

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

Understanding Access Controls and Privileges

3.5.3 Special Row Label PrivilegesOnce the label on a row has been set, Oracle Label Security privileges are required to modify the … label. These privileges include WRITEUP, WRITEDOWN, and WRITEACROSS. Note that the LABEL_UPDATE … enforcement option must be on for these label modification privileges to be enforced. When a user updates … a row label, the new label

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

Understanding Access Controls and Privileges

3.6.1 Multiple Oracle Label Security Policies in a Single Databaseprotecting the table containing your desired rows. If you require privileges, then you may need privileges for all of the policies affecting your work.

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

Administering User Labels and Privileges

8 Administering User Labels and Privilegesprivileges. You can also use the Web interface provided by Oracle Enterprise Manager Database Control or Grid … , with SA_USER_ADMIN Managing User Privileges with SA_USER_ADMIN.SET_USER_PRIVS Setting Labels … & Privileges with SA_SESSION.SET_ACCESS_PROFILE Returning User Name with SA_SESSION.SA_USER_NAME Using Oracle Label Security Views

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

Administering User Labels and Privileges

8.2.11 SA_USER_ADMIN.DROP_ALL_GROUPSThe DROP_ALL_GROUPS procedure drops all groups from a user's authorizations. Syntax: PROCEDURE DROP_ALL_GROUPS (policy_name IN VARCHAR2, user_name IN VARCHAR2); Table 8-11 Parameters for SA_USER_ADMIN.DROP_ALL_GROUPS Parameter Meaning policy_name Specifies the policy user_name Specifies the user name

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

Administering User Labels and Privileges

8.3.4 SA_USER_ADMIN.DROP_USER_ACCESSprivileges from the specified user. This procedure must be issued from the command line. Syntax: PROCEDURE

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

Administering User Labels and Privileges

8.7.1 View to Display All User Security Attributes: DBA_SA_USERSThe DBA_SA_USERS view displays the values assigned for privileges, levels, compartments, and groups

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

Understanding Access Controls and Privileges

3.2.3 Session Label ExampleThe session label and the row label can fall anywhere within the range of the user's level, compartment, and group authorizations. In Figure 3-2, \"User Session Label\", the user's maximum level is SENSITIVE and the minimum level is UNCLASSIFIED. However, his default session label is C:FIN,OP:WR. In this example, the administrator has set the user's session label so that the user connects to the database

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

Administering User Labels and Privileges

8.2.1 SA_USER_ADMIN.SET_LEVELSThe SET_LEVELS procedure assigns a minimum and maximum level to a user and identifies default values for the user's session label and row label. If the min_level is NULL, then it is set to the lowest defined level for the policy. If the def_level is not specified, then it is set to the max_level. If the row_level is not specified, then it is set to the def_level. Syntax: PROCEDURE SET_LEVELS (policy_name

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

Administering User Labels and Privileges

8.2.2 SA_USER_ADMIN.SET_COMPARTMENTSThe SET_COMPARTMENTS procedure assigns compartments to a user and identifies default values for the user's session label and row label. If write_comps are NULL, then they are set to the read_comps. If the def_comps are NULL, then they are set to the read_comps. If the row_comps are NULL, then they are set to the components in def_comps that are authorized for write access. All users must have their

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

Administering User Labels and Privileges

8.2.6 SA_USER_ADMIN.DROP_COMPARTMENTSThe DROP_COMPARTMENTS procedure drops the specified compartments from a user's authorizations. Syntax: PROCEDURE DROP_COMPARTMENTS (policy_name IN VARCHAR2, user_name IN VARCHAR2, comps IN VARCHAR2); Table 8-6 Parameters for SA_USER_ADMIN.DROP_COMPARTMENTS Parameter Meaning policy_name Specifies the policy user_name Specifies the user name comps A comma-delimited list of compartments to drop

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

Administering User Labels and Privileges

8.2.8 SA_USER_ADMIN.ADD_GROUPSThe ADD_GROUPS procedure adds groups to a user, indicating whether the groups are authorized for write as well as read. Syntax: PROCEDURE ADD_GROUPS (policy_name IN VARCHAR2, user_name IN VARCHAR2, groups IN VARCHAR2, access_mode IN VARCHAR2 DEFAULT NULL, in_def IN VARCHAR2 DEFAULT NULL, in_row IN VARCHAR2 DEFAULT NULL); Table 8-8 Parameters for SA_USER_ADMIN.ADD_GROUPS Parameter Meaning policy_name