Granting/Revoking Table Privileges |
To allow other users or groups to access tables in the database, you can grant privileges to them. You can also revoke privileges to deny groups and/or users access to tables. Privileges can be granted to specific functions (Insert, Update, Delete, Index, Reference) or to specific columns of the table.
Users with resource or DBA privilege cannot have their privileges revoked on objects they own. Only by changing the user's authority can these privileges be revoked.
The following list summarizes table privileges:
Select: Users have permission to select any records from the table.
Delete: Users have permission to delete any records from the table.
Insert: Users have permission to insert new records into the table or column.
Update: Users have permission to update any records in the table or column.
Alter: Users have permission to alter the schema of the table.
Index: Users have permission to create an index on the table.
Reference: Users have permission to create referential constraints on the table or column.
Related topic:
Working
With Tables
Changing Security Level
Setting Authority Level
Granting and Removing Object Privileges