Results for privileges


41 to 60 of 2781 results. Prev  Next
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.





Was this page helpful?

Integrated Cloud Applications & Platform Services