Privileges Required for the DBMS_REDEFINITION Package → Execute 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
Privileges → Only 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
Privileges → … Privileges 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.
Auditing Privileges → This 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
Table 18-2 Object Privileges and the Operations They Authorize → Object 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
About Privileges and Roles → on. 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.
Managing Table Privileges → Object 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
Managing Procedure Privileges → This 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
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:
Revoking Object Privileges → privilege 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
About Object Privileges → object privileges include the right to: Update a table Select rows from another user's table Execute a stored procedure of another user
Connection with Administrator Privileges → connect 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
About System Privileges → schema 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
Managing Object Privileges → This 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
Granting Object Privileges → You 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
Managing Application Privileges → Most 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
Managing Type Privileges → The 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
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
Managing System Privileges → This 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
Managing View Privileges → This 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.