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.