user

user

NAME
      user - Junior DBA Wizard to manage users.

SYNTAX
      ext.user

DESCRIPTION
      A collection of wizards to manage users for junior DBAs

methods

create

Wizard to create a user

ext.user.create([verbose][, session])

• verbose: Bool. Show the generated create statement.
• session: Object. The session to be used on the operation

 JS  ext.user.create()
Enter the new user's account: github
Enter the password (leave is blank to generate one): 
Does the user need to change his password ? (Y,n) 
Do you want to lock the account after 3 failed attempts ? (Y,n) 
+--------+------+----------------------+
| user   | host | generated password   |
+--------+------+----------------------+
| github | %    | U8jMLzQ)7Fd[ny)Ji0gl |
+--------+------+----------------------+

 JS  \sql drop user github;
Query OK, 0 rows affected (0.0393 sec)

 JS  ext.user.create(true)
Enter the new user's account: github
Enter the password (leave is blank to generate one): 
Does the user need to change his password ? (Y,n) 
Do you want to lock the account after 3 failed attempts ? (Y,n) 
--> CREATE USER github IDENTIFIED BY RANDOM PASSWORD PASSWORD EXPIRE FAILED_LOGIN_ATTEMPTS 3 PASSWORD_LOCK_TIME 2
+--------+------+----------------------+
| user   | host | generated password   |
+--------+------+----------------------+
| github | %    | +Mcs!)D*dd_CA>_40MIB |
+--------+------+----------------------+