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