GRANT
Applies to: 
Databricks SQL Databricks Runtime
Grants a privilege on an securable object to a principal.
Modifying access to the samples catalog is not supported. This catalog is available to all workspaces, but is read-only.
Use GRANT ON SHARE to grant recipients access to shares.
Syntax
GRANT privilege_types ON securable_object TO principal
privilege_types
{ ALL PRIVILEGES |
privilege_type [, ...] }
Parameters
-
privilege types
This identifies one or more privileges to be granted to the
principal.-
ALL PRIVILEGESGrant all privileges applicable to the
securable_object. In Unity Catalog,ALL PRIVILEGESexpands to all available privileges at the time permissions checks are made. It does not individually grant all of the applicable privileges at the time of the grant. To avoid accidental data exfiltration or privilege escalation,ALL PRIVILEGESdoes not include theEXTERNAL USE SCHEMA,EXTERNAL USE LOCATION, orMANAGEprivileges. -
A specific privilege to be granted on the
securable_objectto theprincipal.
-
-
The object on which the privileges are granted to the principal.
-
A user, service principal, or group to which the privileges are granted. You must enclose users, service principals, and group names with special characters in backticks (
` `).
Examples
> GRANT CREATE ON SCHEMA my_schema TO `alf@melmak.et`;
> GRANT ALL PRIVILEGES ON TABLE forecasts TO finance;
> GRANT SELECT ON TABLE sample_data TO `alf@melmak.et`;
-- Granting a privilege to the service principal fab9e00e-ca35-11ec-9d64-0242ac120002
> GRANT SELECT ON TABLE t TO `fab9e00e-ca35-11ec-9d64-0242ac120002`;