Object-Level Privileges

Database object-level privileges can be granted to and revoked from users.

• Ownership Privileges of Database Objects
  Ownership of a database object carries with it privileges to carry out actions on that object.
• Inheritance of Database Privileges
  You can grant database privileges directly to users, or they can be inherited through role membership.
• Grant and Revoke Object-Level Privileges
  You can grant to users, or revoke from them, combinations of privileges to define their access to database objects.
• Privileges Required to Manage Table Objects in a Dbspace
  The privileges required depend on the task you are performing.
• Command Line Options That Control Privileges
  The database server start-up command start_iq includes options that set the privilege level of some database and server functions.
• Revoking the Privilege to Run a Procedure
  Remove the privilege to execute or call a specific procedure.
• Stored Procedure to Display Object-Level Privileges Granted
  Execute the sp_objectpermission stored procedure to generate a report on object-level privileges granted to the specified role or user name or object privileges granted on the specified object or dbspace.