O'Reilly logo

Practical SQL Handbook, The: Using SQL Variants, Fourth Edition by Sandra L. Emerson, Marcy Darnovsky, Judith S. Bowman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required