Gives a user or group permission to do particular things to a database object; it is a Data Control Language (DCL) statement. To take a permission back use REVOKE, and to block one use DENY.
Read more: Microsoft Learn
In the Ultra Transcenders books
DP-900DP-750DP-600DP-700DP-800
Each book explains GRANT in context, with comparison tables and the common traps.
Terms in this definition
- Chat message roles
Labels on chat messages: instructions go under system, the person's input under user, the model's previous answers under assistant, and results returned by a called tool under tool (or function).
- Schema
The middle part of a Unity Catalog name (
catalog.schema.table), grouping tables, views, volumes, functions and models inside a catalog. A grant on it covers everything in it now and later, and nothing inside can be reached withoutUSE SCHEMA. - DCL
Data Control Language, the SQL statements GRANT, DENY and REVOKE that control permissions on database objects. Database administrators are the people who typically use them.
- REVOKE
A data control (DCL) command that takes away a permission a user or role was earlier granted or denied. The other DCL commands are GRANT and DENY.
- Deny
An Azure Policy effect that stops any create or update request that would break the policy.