![]() Without this role option, roles can only cancel their own queries and sessions. ![]() Allow or disallow a role to cancel queries and sessions of other roles. User and role names share the same namespace and must be unique.ĭeprecated in v22.2: Use the CANCELQUERY system privilege.Object names with these prefixes are reserved for system catalogs. Cannot start with pg_ or crdb_internal.Must contain only letters, numbers, periods, or underscores.Must start with either a letter or underscore.To be able to grant or revoke membership to a role for additional roles, a member of the role must be set as a role admin for that role.ĬREATE ROLE USER IF NOT EXISTS role_spec opt_with role_options Parameters Parameter.To add the LOGIN capability for other roles so that they can log in as users, a role must also have the CREATELOGIN role option.To create other roles, a role must have the CREATEROLE role option.Unless a role is a member of the admin role, additional privileges are required to manage other roles. Membership loops are not allowed (direct: A is a member of B is a member of A or indirect: A is a member of B is a member of C.There is no limit to the number of members in a role.Role options of a role are not inherited by any of its members.Users and roles can be members of roles.All privileges of a role are inherited by all of its members.After creating a role, you must grant it privileges to databases and tables.For more information about how online schema changes work in CockroachDB, see Online Schema Changes. The CREATE ROLE statement performs a schema change.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |