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.

• Granting the ALTER Privilege on Tables
  Grant the privilege to alter the structure of a table. This privilege does not apply to views.
• Granting the DELETE Privilege on Tables and Views
  Grant the privilege to delete all data in a specified table or view.
• Granting the INSERT Privilege on Tables and Views
  Grant the privilege to insert data into a table or view.
• Granting the LOAD Privilege on Tables
  Grant the privilege to load a specified table.
• Granting the REFERENCES Privilege on Tables
  Grant the privilege to indexes and to foreign keys on a table. This privilege does not apply to views. This privilege can be restricted to a set of columns in the table.
• Granting the SELECT Privilege on Tables and Views
  Grant the privilege to select data in a table or view, but not to alter it. This privilege can be restricted to a set of columns in the table.
• Granting the TRUNCATE Privilege on Tables
  Grant the privilege to truncate a specified table.
• Granting the UPDATE Privilege on Tables and Views
  Grant the privilege to modify the data in a table or view. This privilege can be restricted to a set of columns in the table.
• Granting the Right to Administer an Object-Level Privilege
  Grant the privilege to allow a user to pass a specific object privilege on to other users.
• Granting the CREATE Privilege on Dbspaces
  Grant the privilege to create database objects in the specified dbspace.
• Granting the EXECUTE Privilege on Functions and Procedures
  Grant the privilege to run a procedure or user-defined function.
• Granting the USAGE Privilege on Sequence Generators
  Grant the privilege to evaluate the current or next value in a sequence.
• Revoking an Object-Level Privilege
  Remove the ability of a user to use a specific object-level privilege, or to grant the privilege to other users.