Results for privileges


1 to 60 of 2781 results. Prev  Next
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.

Database Performance Tuning Guide, 11g Release 1 (11.1)

SQL Access Advisor

18.2.2 Privileges Needed to Use the SQL Access Advisorthe 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

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Managing a Recovery Catalog

Revoking Privileges from a Virtual Private Catalog Ownercatalog, 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

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Managing a Recovery Catalog

Creating and Granting Privileges to a Virtual Private Catalog Owneraccess 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

Database Security Guide, 11g Release 1 (11.1)

Configuring Privilege and Role Authorization

Revoking System Privileges and RolesYou can revoke system privileges and roles using the SQL statement REVOKE. Any user with the ADMIN

Database Security Guide, 11g Release 1 (11.1)

Configuring Privilege and Role Authorization

Granting and Revoking System PrivilegesYou 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 privilegesprivileges to or from users and roles: GRANT and REVOKE SQL statements Oracle Enterprise Manager

Database Data Warehousing Guide, 11g Release 1 (11.1)

Basic Query Rewrite

Privileges for Enabling Query RewriteUse 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

Database Security Guide, 11g Release 1 (11.1)

Configuring Privilege and Role Authorization

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

Database Security Guide, 11g Release 1 (11.1)

Configuring Privilege and Role Authorization

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

Database Security Guide, 11g Release 1 (11.1)

Configuring Privilege and Role Authorization

Granting Administrative Privileges to UsersAs 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

Database Security Guide, 11g Release 1 (11.1)

Configuring Privilege and Role Authorization

Granting or Revoking Object PrivilegesEach 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.

Database Security Guide, 11g Release 1 (11.1)

Configuring Privilege and Role Authorization

Granting System Privileges and RolesYou 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

Warehouse Builder Installation and Administration Guide for Windows and UNIX, 11g Release 1 (11.1)

Implementing Security in Warehouse Builder

System PrivilegesObject 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 Security Administrator's Guide, 11g Release 1 (11.1)

Getting Started with Oracle Label Security

Label PrivilegesCHAR(2) You will apply the following labels: Label Privileges CONFIDENTIAL Read access to the cities

Database Security Guide, 11g Release 1 (11.1)

Configuring Privilege and Role Authorization

About ANY Privileges and the PUBLIC RoleSystem 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

Database Security Guide, 11g Release 1 (11.1)

Configuring Privilege and Role Authorization

Granting a User Privileges and RolesThis 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

Database Security Guide, 11g Release 1 (11.1)

Configuring Privilege and Role Authorization

Revoking Privileges and Roles from a UserThis section contains: Revoking System Privileges and Roles Revoking Object Privileges Cascading Effects of Revoking Privileges

Database Security Guide, 11g Release 1 (11.1)

Keeping Your Oracle Database Secure

Guidelines for Securing User Accounts and PrivilegesFollow 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

Database Security Guide, 11g Release 1 (11.1)

Managing Security for Application Developers

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

Database Security Guide, 11g Release 1 (11.1)

Configuring Privilege and Role Authorization

Table 4-5 Privileges for Object Tablestable 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

Database Security Guide, 11g Release 1 (11.1)

Managing Security for Application Developers

SQL Statements Permitted by Object Privilegesthat each user is assigned the proper roles. Table 5-3 lists the SQL statements permitted by the object privileges shown in Table 5-2.





Was this page helpful?

Integrated Cloud Applications & Platform Services