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
18.2.2 Privileges Needed to Use the SQL Access Advisor → the 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
Revoking Privileges from a Virtual Private Catalog Owner → catalog, 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
Creating and Granting Privileges to a Virtual Private Catalog Owner → access 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
Revoking System Privileges and Roles → You can revoke system privileges and roles using the SQL statement REVOKE. Any user with the ADMIN
Granting and Revoking System Privileges → You 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 privileges … privileges to or from users and roles: GRANT and REVOKE SQL statements Oracle Enterprise Manager
Privileges for Enabling Query Rewrite → Use 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
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
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
Granting Administrative Privileges to Users → As 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
Granting or Revoking Object Privileges → Each 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.
Granting System Privileges and Roles → You 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
System Privileges → Object 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 Privileges → CHAR(2) You will apply the following labels: Label Privileges CONFIDENTIAL Read access to the cities
About ANY Privileges and the PUBLIC Role → System 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
Granting a User Privileges and Roles → This 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
Revoking Privileges and Roles from a User → This section contains: Revoking System Privileges and Roles Revoking Object Privileges Cascading Effects of Revoking Privileges
Guidelines for Securing User Accounts and Privileges → Follow 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
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
Table 4-5 Privileges for Object Tables → table 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