Results for privileges


21 to 40 of 2781 results. Prev  Next
Results per page:   20  | 40 | 60


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.





Was this page helpful?

Integrated Cloud Applications & Platform Services