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 20 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,