Grant a permission to a user or role.

Syntax

grant <permission> on organization <object ref> to { user <username> | role <role name> }
grant <permission> on repository <object ref> to { user <username> | role <role name> }
grant <permission> on { data source | schema | project | table | job } <object ref> [in repository <repo name>] to { user <username> | role <role name> }
grant <permission> on secret <object ref> to { user <username> | role <role name> }

Parameters

permission

String. Name of the permission type to grant. One of: Admin, Developer, Write, Execute, Read, Use, Lineage.

object ref

String. The (optionally qualified) name of the object to grant the permission on.

repo name

String. The name of the repository that the target object resides in. Only valid for data sources, schemas, projects, tables, and jobs. Defaults to the current repository.

username or role name

String. The name of the principal to grant the permission to, either a user or a role.

Security

Restricted to admins of the organization the target object resides in.