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


1 to 40 of 2781 results. Previous page Prev  Next next page
Results per page:  20 |  40  | 60


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

Scheduler Reference

Scheduler PrivilegesTable 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

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

Database Administrator Authentication

Administrative PrivilegesAdministrative 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

Database Concepts, 11g Release 1 (11.1)

Database Security

PrivilegesA 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\"

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

Managing User Privileges and Roles

Managing User Privileges and RolesPrivileges 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

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

Creating Location Transparency

Managing Procedures and Privilegessecurity. Privileges for objects referenced within a procedure do not need to be explicitly granted to the calling users.

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

Assigning Sessions to Resource Consumer Groups

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

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

Creating Location Transparency

Managing Privileges and Synonymsschema 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 scott.emp@sales.acme.com. scott cannot grant object privileges on the … synonym to another local user.

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

About Database Administrator Security and Privileges

The DBA Rolecontains 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,

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

About Database Administrator Security and Privileges

SYSWhen 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

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

About Database Administrator Security and Privileges

The Database Administrator's Operating System Accountsystem account might require operating system privileges or access rights that other database users

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

About Database Administrator Security and Privileges

Administrative User AccountsTwo 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

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

About Database Administrator Security and Privileges

SYSTEMWhen 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.

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

About Database Administrator Security and Privileges

About Database Administrator Security and PrivilegesTo perform the administrative tasks of an Oracle Database DBA, you need specific privileges within

Database SQL Language Reference, 11g Release 1 (11.1)

GRANT

Table 18-1 System PrivilegesSystem 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

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

About Oracle Database Resource Manager

About Resource Manager Administration PrivilegesYou 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

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Using Triggers

Privileges Required to Use Triggerstrigger but not alter it. The object privileges to the schema objects referenced in the trigger body

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

Database Administrator Authentication

Connecting with Administrative Privileges: ExampleThis 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

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

Creating and Maintaining a Password File

Granting and Revoking SYSDBA and SYSOPER Privilegesprivileges, 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

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

Creating Database Links

Obtaining Privileges Necessary for Creating Database Linksdatabase. 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

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

Managing External Tables

System and Object Privileges for External TablesSystem 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,

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

Redefining Tables Online

Privileges Required for the DBMS_REDEFINITION PackageExecute 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

Ultra Search Administrator's Guide, 11g Release 1 (11.1)

Understanding the Oracle Ultra Search Administration Tool

PrivilegesOnly 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

XML DB Developer's Guide, 11g Release 1 (11.1)

Access Control Lists and Security Classes

PrivilegesPrivileges 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.

Database Security Guide, 11g Release 1 (11.1)

Verifying Security Access with Auditing

Auditing PrivilegesThis 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

Database SQL Language Reference, 11g Release 1 (11.1)

GRANT

Table 18-2 Object Privileges and the Operations They AuthorizeObject 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

Database Security Guide, 11g Release 1 (11.1)

Configuring Privilege and Role Authorization

About Privileges and Roleson. 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.

Database Security Guide, 11g Release 1 (11.1)

Configuring Privilege and Role Authorization

Managing Table PrivilegesObject 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

Database Security Guide, 11g Release 1 (11.1)

Configuring Privilege and Role Authorization

Managing Procedure PrivilegesThis 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

Database Security Guide, 11g Release 1 (11.1)

Configuring Privilege and Role Authorization

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:

Database Security Guide, 11g Release 1 (11.1)

Configuring Privilege and Role Authorization

Revoking Object Privilegesprivilege 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

Database Security Guide, 11g Release 1 (11.1)

Configuring Privilege and Role Authorization

About Object Privilegesobject privileges include the right to: Update a table Select rows from another user's table Execute a stored procedure of another user

Database Concepts, 11g Release 1 (11.1)

Database and Instance Startup and Shutdown

Connection with Administrator Privilegesconnect 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

Database Security Guide, 11g Release 1 (11.1)

Configuring Privilege and Role Authorization

About System Privilegesschema 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

Database Security Guide, 11g Release 1 (11.1)

Configuring Privilege and Role Authorization

Managing Object PrivilegesThis 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

Database Security Guide, 11g Release 1 (11.1)

Configuring Privilege and Role Authorization

Granting Object PrivilegesYou 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

Database Security Guide, 11g Release 1 (11.1)

Managing Security for Application Developers

Managing Application PrivilegesMost 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

Database Security Guide, 11g Release 1 (11.1)

Configuring Privilege and Role Authorization

Managing Type PrivilegesThe 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

Database Concepts, 11g Release 1 (11.1)

Database Security

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

Database Security Guide, 11g Release 1 (11.1)

Configuring Privilege and Role Authorization

Managing System PrivilegesThis 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

Database Security Guide, 11g Release 1 (11.1)

Configuring Privilege and Role Authorization

Managing View PrivilegesThis 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.