8.8 SQL Data Control Language (DCL)
SQL has an authorization sublanguage, data control language (DCL), that includes statements to grant privileges to and revoke privileges from users. A privilege is an action, such as creating, executing, reading, updating, or deleting, that a user is permitted to perform on database objects. In standard SQL, the creator of a schema is given all privileges on all the objects (tables, views, roles, applications) in it, and can pass those privileges on to others. Ordinarily, only the creator of the schema can modify the schema (adding tables, columns, and so on). The statement for granting privileges has the following form
The possible privileges for base tables are SELECT, DELETE, INSERT, UPDATE, or REFERENCES( ...
Get Databases Illuminated, 4th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.