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...