tailieunhanh - Managing Privileges

Managing Privileges A privilege is a right to execute a particular type of SQL statement or to access another user’s object. These include the right to: Connect to a database Create a table Select rows from another user’s table Execute another user’s stored procedure System privileges Each system privilege allows a user to perform a particular database operation or class of database operations; for example, the privilege to create tablespaces is a system privilege. Object privileges Each object privilege allows a user to perform a particular action on a specific object, such as a table, view, sequence, procedure, function, or package. A DBA’s control of privileges includes: Providing a user the. | Managing Privileges Objectives After completing this lesson, you should be able to do the following: Identify system and object privileges Grant and revoke privileges Obtain privilege information There are two types of Oracle user privileges: System: Enables users to perform particular actions in the database Object: Enables users to access and manipulate a specific object Managing Privileges Managing Privileges A privilege is a right to execute a particular type of SQL statement or to access another user’s object. These include the right to: Connect to a database Create a table Select rows from another user’s table Execute another user’s stored procedure System privileges Each system privilege allows a user to perform a particular database operation or class of database operations; for example, the privilege to create tablespaces is a system privilege. Object privileges Each object privilege allows a user to perform a particular action on a specific object, such as a table, view, sequence, procedure, function, or package. A DBA’s control of privileges includes: Providing a user the right to perform a type of operation Granting and revoking access to perform system functions Granting privileges directly to users or to roles Granting privileges to all users (PUBLIC) More than 100 distinct system privileges ANY keyword in privileges signifies that users have the privilege in any schema. GRANT command adds a privilege to a user or a group of users. REVOKE command deletes the privileges. System Privileges System Privileges Privileges can be classified as follows: Privileges that enable system-wide operations; for example, CREATE SESSION, CREATE TABLESPACE Privileges that enable management of objects in a user’s own schema; for example, CREATE TABLE Privileges that enable management of objects in any schema; for example, CREATE ANY TABLE Privileges can be controlled with the DDL commands GRANT and REVOKE, which add and revoke system privileges to the user or to a role. | Managing Privileges Objectives After completing this lesson, you should be able to do the following: Identify system and object privileges Grant and revoke privileges Obtain privilege information There are two types of Oracle user privileges: System: Enables users to perform particular actions in the database Object: Enables users to access and manipulate a specific object Managing Privileges Managing Privileges A privilege is a right to execute a particular type of SQL statement or to access another user’s object. These include the right to: Connect to a database Create a table Select rows from another user’s table Execute another user’s stored procedure System privileges Each system privilege allows a user to perform a particular database operation or class of database operations; for example, the privilege to create tablespaces is a system privilege. Object privileges Each object privilege allows a user to perform a particular action on a specific object, such as a table, view, .