The GRANT and REVOKE Commands

The phrases “granting privileges” or “assigning permissions” are often associated with discussions of GRANT and REVOKE. In most implementations of SQL, you can't do anything for which you don't have explicit authorization—either by being an object owner or a database administrator or by having been granted access with the GRANT command.

The GRANT and REVOKE commands specify which users can perform which operations on which tables, views, or columns. In addition, permission must also be explicitly granted (usually by the database administrator) to execute commands such as CREATE TABLE.

GRANT and REVOKE Syntax

The operations associated with GRANT and REVOKE include SELECT, UPDATE, INSERT, DELETE, and REFERENCES; and ...

Get Practical SQL Handbook, The: Using SQL Variants, Fourth Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.