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,