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
Scheduler Privileges → Table 28-2 lists the various Scheduler privileges. Table 28-2 Scheduler Privileges Privilege Name … Operations Authorized System Privileges: CREATE JOB This privilege enables you to create jobs … agent password for a database. Object Privileges: EXECUTE This privilege can only be granted for … allowed by all
Administrative Privileges → Administrative privileges that are required for an administrator to perform basic database … operations are granted through two special system privileges, SYSDBA and SYSOPER. You must have one of these … privileges granted to you, depending upon the level of authorization you require. Note: The SYSDBA … and SYSOPER system privileges
Privileges → A privilege is a right to run a particular type of SQL statement. Some examples of privileges … Guide for more information on privileges \"Introduction to Privileges\"
Managing User Privileges and Roles → Privileges 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 … privileges allow users to perform specific database operations. Object privilege A system-defined … privilege that controls access
Managing Procedures and Privileges → security. Privileges for objects referenced within a procedure do not need to be explicitly granted to the calling users.
Revoking Switch Privileges → => 'OLTP'); END; If you revoke a user's switch privileges for a particular consumer group, any subsequent … DEFAULT_CONSUMER_GROUP upon login. If you revoke from a role the switch privileges to a consumer group, any users who … had switch privileges for the consumer group only through that role are no longer able to switch to
Managing Privileges and Synonyms → schema object must also have privileges on the underlying schema object itself. For example, if the … user attempts to access a synonym but does not have privileges on the table it identifies, an error … alias for remote object email@example.com. scott cannot grant object privileges on the … synonym to another local user.
The DBA Role → contains most database system privileges. Therefore, the DBA role should be granted only to actual … database administrators. Note: The DBA role does not include the SYSDBA or SYSOPER system privileges … . These are special administrative privileges that allow an administrator to perform basic database … administration tasks,
SYS → When you create an Oracle Database, the user SYS is automatically created and granted the DBA role. All of the base tables and views for the database data dictionary are stored in the schema SYS. These base tables and views are critical for the operation of Oracle Database. To maintain the integrity of the data dictionary, tables in the SYS schema are manipulated only by the database. They should
The Database Administrator's Operating System Account → system account might require operating system privileges or access rights that other database users
Administrative User Accounts → Two administrative user accounts are automatically created when Oracle Database is installed: SYS (default password: CHANGE_ON_INSTALL ) SYSTEM (default password: MANAGER ) Note: Both Oracle Universal Installer (OUI) and Database Configuration Assistant (DBCA) now prompt for SYS and SYSTEM passwords and do not accept the default passwords \"change_on_install\" or \"manager\", respectively. If you
SYSTEM → When you create an Oracle Database, the user SYSTEM is also automatically created and granted the DBA role. The SYSTEM username is used to create additional tables and views that display administrative information, and internal tables and views used by various Oracle Database options and tools. Never use the SYSTEM schema to store tables of interest to non-administrative users.
About Database Administrator Security and Privileges → To perform the administrative tasks of an Oracle Database DBA, you need specific privileges within
Table 18-1 System Privileges → System Privilege Name Operations Authorized Advisor Framework Privileges: All of the advisor … framework privileges are part of the DBA role. — ADVISOR Access the advisor framework through PL/SQL … schema. DROP ANY INDEX Drop indexes in any schema. JOB SCHEDULER OBJECTS: The following privileges … are needed to execute procedures
About Resource Manager Administration Privileges → You must have the system privilege ADMINISTER_RESOURCE_MANAGER to administer the Resource Manager. This privilege (with the ADMIN option) is granted to database administrators through the DBA role. Being an administrator for the Resource Manager enables you to execute all of the procedures in the DBMS_RESOURCE_MANAGER PL/SQL package. You may, as an administrator with the ADMIN option, choose to grant
Privileges Required to Use Triggers → trigger but not alter it. The object privileges to the schema objects referenced in the trigger body
Connecting with Administrative Privileges: Example → This example illustrates that a user is assigned another schema ( SYS ) when connecting with the SYSDBA system privilege. Assume that the sample user oe has been granted the SYSDBA system privilege and has issued the following statements: CONNECT oe CREATE TABLE admin_test(name VARCHAR2(20)); Later, user oe issues these statements: CONNECT oe AS SYSDBA SELECT * FROM admin_test; User oe now receives
Granting and Revoking SYSDBA and SYSOPER Privileges → privileges, the WITH ADMIN OPTION is not used in the GRANT statement. That is, the grantee cannot in turn … grant or revoke another user's SYSDBA or SYSOPER system privileges. These privileges cannot be … SYSOPER database privileges with operating system roles. See Also: Oracle Database Security Guide for more information
Obtaining Privileges Necessary for Creating Database Links → database. To create a private database link, you must have been granted the proper privileges. The … following table illustrates which privileges are required on which database for which type of link … of database link. To see which privileges you currently have available, query ROLE_SYS_PRIVS. For … DISTINCT PRIVILEGE AS \"Database
System and Object Privileges for External Tables → System and object privileges for external tables are a subset of those for regular table. Only the … following system privileges are applicable to external tables: CREATE ANY TABLE ALTER ANY TABLE DROP … ANY TABLE SELECT ANY TABLE Only the following object privileges are applicable to external tables … : ALTER SELECT However,
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.
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