You are viewing an older version of this section. View current production version.
SingleStore Managed Service does not support this command.
Create a role on a cluster.
CREATE ROLE 'role_name' WITH [FAILED_LOGIN_ATTEMPTS = integer] [PASSWORD_LOCK_TIME = integer]
FAILED_LOGIN_ATTEMPTS: Together with
PASSWORD_LOCK_TIME, specifies the failed login attempt lockout behavior.
FAILED_LOGIN_ATTEMPTS is the number of failed attempts allowed before the account is locked out. Default is
0 which means there is no restriction. When set to a value >=1,
PASSWORD_LOCK_TIME must also be specified.
PASSWORD_LOCK_TIME: Together with
FAILED_LOGIN_ATTEMPTS, specifies the failed login attempt lockout behavior.
PASSWORD_LOCK_TIME is the number of seconds a locked out account must wait before reattempting to log in.
You must set both
PASSWORD_LOCK_TIME to enable the lockout feature.
To change the values for
PASSWORD_LOCK_TIME for a role, drop and then re-create the role.
For more information about failed login attempt lockout behavior, see Securing SingleStore DB.
CREATE ROLE 'role_name'; Query OK, 0 rows affected (0.06 sec)