nz_ddl_user <USER_NAME>
\echo
\echo ***** Creating user: "<USER_NAME>"
CREATE USER <USER_NAME> WITH PASSWORD 'password' ;
\echo
\echo ***** Updating password for user: "<USER_NAME>"
UPDATE _t_user_options SET passwd = '$1$/+CQzTNi+1I9$QqgdELb4KLkNiFqr8cN4Jg==' WHERE usename = ^<USER_NAME>^;
UPDATE _t_user SET passwd = '$1$/+CQzTNi+1I9$QqgdELb4KLkNiFqr8cN4Jg==' WHERE usename = ^<USER_NAME>^;
it will set the password as 'password'
No comments:
Post a Comment