| BYPASSRLS/NOBYPASSRLS | : Allow or disallow a role to bypass policies on a table. This option controls the access from an RLS perspective only; the user also needs sufficient privileges to read or write to the table. |
CANCELQUERY/NOCANCELQUERY | Deprecated in v22.2: Use the CANCELQUERY. Allow or disallow a role to cancel and of other roles. Without this role option, roles can only cancel their own queries and sessions. Even with the CANCELQUERY role option, non-admin roles cannot cancel admin queries or sessions. This option should usually be combined with VIEWACTIVITY so that the role can view other roles’ query and session information. By default, the role option is set to NOCANCELQUERY for all non-admin roles. | |
CONTROLCHANGEFEED/NOCONTROLCHANGEFEED | Deprecated in v23.1: Use the CHANGEFEED. Allow or disallow a role to run on tables they have SELECT privileges on. By default, the role option is set to NOCONTROLCHANGEFEED for all non-admin roles. | |
CONTROLJOB/NOCONTROLJOB | Allow or disallow a role to , , and jobs. Non-admin roles cannot control jobs created by admin roles. By default, the role option is set to NOCONTROLJOB for all non-admin roles. | |
CREATEDB/NOCREATEDB | Allow or disallow a role to or a database. The role is assigned as the owner of the database. By default, the role option is set to NOCREATEDB for all non-admin roles. | |
CREATELOGIN/NOCREATELOGIN | Allow or disallow a role to manage authentication using the WITH PASSWORD, VALID UNTIL, and LOGIN/NOLOGIN role options. By default, the role option is set to NOCREATELOGIN for all non-admin roles. | |
CREATEROLE/NOCREATEROLE | Allow or disallow the new role to , alter, and other non-admin roles. By default, the role option is set to NOCREATEROLE for all non-admin roles. | |
LOGIN/NOLOGIN | Allow or disallow a role to log in with one of the . Setting the role option to NOLOGIN prevents the role from logging in using any authentication method. | |
MODIFYCLUSTERSETTING/NOMODIFYCLUSTERSETTING | Allow or disallow a role to modify the with the sql.defaults prefix. By default, the role option is set to NOMODIFYCLUSTERSETTING for all non-admin roles. | |
PASSWORD password/PASSWORD NULL | The credential the role uses to . A password should be entered as a . For compatibility with PostgreSQL, a password can also be entered as an identifier. To prevent a role from using and to mandate , . | |
PROVISIONSRC | A system-managed role option that identifies the authentication method and identity provider that automatically provisioned this user. The format is {method}:{provider} where method is ldap, oidc, or jwt\_token. Examples: ldap:example.com, oidc:https://accounts.google.com, jwt\_token:https://auth.example.com. This option is set automatically during , , or user provisioning and cannot be modified or removed. Users with this option cannot change their own passwords. | |
SQLLOGIN/NOSQLLOGIN | Deprecated in v22.2: Use the NOSQLLOGIN. Allow or disallow a role to log in using the SQL CLI with one of the . The role option to NOSQLLOGIN prevents the role from logging in using the SQL CLI with any authentication method while retaining the ability to log in to DB Console. It is possible to have both NOSQLLOGIN and LOGIN set for a role and NOSQLLOGIN takes precedence on restrictions. Without any role options all login behavior is permitted. | |
VALID UNTIL | The date and time (in the format) after which the password is not valid. | |
VIEWACTIVITY/NOVIEWACTIVITY | Deprecated in v22.2: Use the VIEWACTIVITY. Allow or disallow a role to see other roles’ and using SHOW STATEMENTS, SHOW SESSIONS, and the and pages in the DB Console. VIEWACTIVITY also permits visibility of node hostnames and IP addresses in the DB Console. With NOVIEWACTIVITY, the SHOW commands show only the role’s own data, and DB Console pages redact node hostnames and IP addresses. By default, the role option is set to NOVIEWACTIVITY for all non-admin roles. | |
VIEWCLUSTERSETTING / NOVIEWCLUSTERSETTING | Deprecated in v22.2: Use the VIEWCLUSTERSETTING. Allow or disallow a role to view the with SHOW CLUSTER SETTING or to access the page in the DB Console. By default, the role option is set to NOVIEWCLUSTERSETTING for all non-admin roles. | |
VIEWACTIVITYREDACTED/NOVIEWACTIVITYREDACTED | Deprecated in v22.2: Use the VIEWACTIVITYREDACTED. Allow or disallow a role to see other roles’ queries and sessions using SHOW STATEMENTS, SHOW SESSIONS, and the Statements and Transactions pages in the DB Console. With VIEWACTIVITYREDACTED, a user will not have access to the usage of statements diagnostics bundle (which can contain PII information) in the DB Console, and will not be able to list queries containing for other users when using the listSessions endpoint through the . It is possible to have both VIEWACTIVITY and VIEWACTIVITYREDACTED, and VIEWACTIVITYREDACTED takes precedence on restrictions. If the user has VIEWACTIVITY but doesn’t have VIEWACTIVITYREDACTED, they will be able to see DB Console pages and have access to the statements diagnostics bundle. By default, the role option is set to NOVIEWACTIVITYREDACTED for all non-admin roles. | |
