GRANT
Applies to: Databricks SQL Databricks Runtime
Grants a privilege on an securable object to a principal.
Note
Modifying access to the samples
catalog is not supported. This catalog is available to all workspaces, but is read-only.
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 PRIVILEGES
Grant all privileges applicable to the
securable_object
. In Unity Catalog,ALL PRIVILEGES
expands 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_object
to 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 (
` `
).