Managing Group Object Privileges |
Object privileges control which database objects a user can access and the actions they can perform. There are seven object privileges: SELECT, INSERT, DELETE, UPDATE, INDEX, ALTER, and REFERENCE.
SELECT privilege allows you to select the data in a database object. This privilege applies to the entire object and cannot be granted on specific columns. INSERT privilege allows you to insert new data into a database object. This privilege can also be restricted to specific columns.
DELETE privilege allows you to delete data from a database object. This privilege applies to the entire object and cannot be granted on specific columns.
UPDATE privilege allows you to update data in a database object. This privilege can also be restricted to specific columns.
INDEX privilege allows you to create an index on a database object. This privilege applies to the entire object and cannot be granted on specific columns.
ALTER privilege allows you to alter the schema of a database object. This privilege applies to the entire object and cannot be granted on specific columns.
REFERENCE privilege allows you to create referential constraints (such as foreign keys) on a database object. This privilege can also be restricted to specific columns.
EXECUTE privilege allows the user to use a stored procedure or command.
It is possible to grant object privileges to all users simultaneously by granting the privileges to PUBLIC. All current and future users will then have those privileges on the database object.
Related topic: