GRANT

Applies to: check marked yes Databricks SQL check marked yes 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.

    • privilege type

      A specific privilege to be granted on the securabel_object to the principal.

  • securable_object

    The object on which the privileges are granted to the principal.

  • 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 <schema-name> TO `alf@melmak.et`;

> GRANT ALL PRIVILEGES ON TABLE forecasts TO finance;

> GRANT SELECT ON TABLE sample_data TO USERS;