Friday, October 24, 2014

How to generate DDL for user in Netezza?

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