Granting/Revoking Table Privileges

How To

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:


Related topic:

Working With Tables
Changing Security Level

Setting Authority Level

Granting and Removing Object Privileges