Example (standard-style syntax). Verify supported keywords in your database.
GRANT reporting_reader TO analyst;SQL GRANT ROLE
Assign a role to a principal using database-specific syntax.
Syntax
GRANT role_name TO principal;Examples
SQLite-oriented variant; dialect behaviour may differ.
GRANT reporting_reader TO analyst;Parameters, options and clauses
| Option / clause | Description |
|---|---|
Principal | Specify the user, role or other database principal. |
Privilege | Choose permissions such as SELECT, INSERT, UPDATE or EXECUTE. |
ON object | Set the database object or scope to which a privilege applies. |
TO / FROM | Name a grantee for GRANT or a principal for REVOKE. |
WITH GRANT OPTION | Allow onward grants where the database supports it. |
Dialect references
Review a command and its target before running it. Commands that alter files, services, accounts, disks, permissions or databases may be difficult to reverse. Test in a safe environment and keep backups.