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
Privileges Required for the DBMS_REDEFINITION Package → Execute privileges on the DBMS_REDEFINITION package are granted to EXECUTE_CATALOG_ROLE. In … addition to having execute privileges on this package, you must be granted the following privileges: CREATE … privileges are required to execute COPY_TABLE_DEPENDENTS: CREATE ANY TRIGGER CREATE ANY INDEX
Privileges → Only instance owners, user s that have been granted general administrative privileges on this … instance, or super-users are permitted to access the Privileges page. Instance owners must have been … values to add privileges to another single sign-on user. These users are authenticated by OracleAS … Single Sign-On before enabling
Privileges → … Privileges A privilege is a particular right or permission that can be granted or denied to a … principal. Oracle Database has a set of system-defined privileges (such as READ or UPDATE ). Applications can define additional, custom privileges.
Auditing Privileges → This section contains: About Privilege Auditing Types of Privileges That Can Be Audited Configuring … privilege auditing is BY ACCESS. Types of Privileges That Can Be Audited You can audit the use of any … permitted by the existing owner and object privileges. Privilege auditing is triggered only if the … privileges
Table 18-2 Object Privileges and the Operations They Authorize → Object Privilege Operations Authorized DIRECTORY PRIVILEGES The following directory privileges … . Granting object privileges on the directory database object to individual database users, rather than … invoke its methods. MATERIALIZED VIEW PRIVILEGES The following materialized view privileges authorize
About Privileges and Roles → on. 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 … : System privileges.
Managing Table Privileges → Object privileges for tables enable table security at the DML (data manipulation language) or DDL … (data definition language) level of operation. The following sections discuss table privileges and … DML and DDL operations: How Table Privileges Affect Data Manipulation Language Operations How Table … Privileges
Managing Procedure Privileges → This section contains: Using the EXECUTE Privilege for Procedure Privileges Procedure Execution and … Security Domains How Procedure Privileges Affect Definer's Rights How Procedure Privileges Affect … Invoker's Rights System Privileges Required to Create or Replace a Procedure System Privileges
Managing Object Privileges → … Different object privileges are available for different types of schema objects. The privilege to … as clusters, indexes, triggers, and database links, do not have associated object privileges. Their … use is controlled with system privileges. For example, to alter a cluster, a user must own the … revoking such privileges:
Revoking Object Privileges → privilege that enables you to grant and revoke privileges on behalf of the object owner. You can only … revoke the privileges that you, the person who granted the privilege, directly authorized. You cannot … a cascading effect. If the object privileges of the user who granted the privilege are revoked … INSERT privileges
About Object Privileges → object privileges include the right to: Update a table Select rows from another user's table Execute a stored procedure of another user
Connection with Administrator Privileges → connect to Oracle Database with administrator privileges. Depending on the operating system, one of … the following conditions establishes administrator privileges for a user: The user's operating system … privileges allow him or her to connect using administrator privileges. The user is granted the … SYSDBA or
About System Privileges → schema objects of a particular type. For example, the privileges to create tablespaces and to delete the … rows of any table in a database are system privileges. There are over 100 distinct system privileges … database operations. Remember that system privileges are very powerful. Only grant them when necessary to
Managing Object Privileges → This section contains: About Object Privileges Granting or Revoking Object Privileges Managing … Object Privileges Managing Table Privileges Managing View Privileges Managing Procedure Privileges Managing Type Privileges
Granting Object Privileges → You can use the GRANT statement to grant object privileges to roles and users. To grant an object … revoke privileges on behalf of the object owner. The WITH GRANT OPTION clause was specified when … you were granted the object privilege. Note: System privileges and roles cannot be granted along with … object privileges
Managing Application Privileges → Most database applications involve different privileges on different schema objects. Keeping track … of the privileges that are required for each application can be complex. In addition, authorizing … management, you can create a role for each application and grant that role all the privileges a user must … of privileges
Managing Type Privileges → The following sections describe the use of privileges for types, methods, and objects: System … Privileges for Named Types Object Privileges Method Execution Model Privileges Required to Create Types … and Tables Using Types Example of Privileges for Creating Types and Tables Using Types Privileges
Introduction to Privileges → … Grant privileges to users so that they can accomplish tasks required for their job. Grant … privileges only to users who absolutely require them. Excessive granting of unnecessary privileges can … compromise security. A user can receive a privilege in two different ways: You can grant privileges to
Managing System Privileges → This section contains: About System Privileges Why Is It Important to Restrict System Privileges … ? Granting and Revoking System Privileges Who Can Grant or Revoke System Privileges? About ANY Privileges and the PUBLIC Role
Managing View Privileges → This section contains: About View Privileges Privileges Required to Create Views Increasing Table … Security with Views About View Privileges A view is a presentation of data selected from one or more … constraints and triggers of the base tables. You can apply DML object privileges to views, similar … to tables.