On this page
Create a role on a SingleStoreDB cluster.
CREATE ROLE 'role_name' WITH [FAILED_LOGIN_ATTEMPTS = integer] [PASSWORD_LOCK_TIME = integer]
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.
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.
You must set both
PASSWORD_ to enable the lockout feature.
To change the values for
PASSWORD_ for a role, drop and then re-create the role.
For more information about failed login attempt lockout behavior, see SingleStoreDB User Management.
CREATE ROLE 'role_name';
Query OK, 0 rows affected (0.06 sec)
Last modified: August 18, 2023