CREATE ROLE
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
Create a role on a SingleStore cluster.
Syntax
CREATE ROLE 'role_name' WITH [FAILED_LOGIN_ATTEMPTS = integer] [PASSWORD_LOCK_TIME = integer]
Arguments
FAILED_PASSWORD_
, specifies the failed login attempt lockout behavior.FAILED_
is the number of failed attempts allowed after which the account is locked out.PASSWORD_
must also be specified.
PASSWORD_FAILED_
, specifies the failed login attempt lockout behavior.PASSWORD_
is the number of seconds a locked out account must wait before reattempting to log in.
Note
You must set both FAILED_
and PASSWORD_
to enable the lockout feature.
Note
To change the values for FAILED_
and PASSWORD_
for a role, drop and then re-create the role.
For more information about failed login attempt lockout behavior, see SingleStore User Management.
Remarks
-
This command causes implicit commits.
Refer to COMMIT for more information. -
Refer to the Permission Matrix for the required permission.
Example
CREATE ROLE 'role_name';
Query OK, 0 rows affected (0.06 sec)
Last modified: August 18, 2023