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.
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 PRIVILEGES
Grant all privileges applicable to the
securable_object
.-
A specific privilege to be granted on the
securabel_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 (
` `
).