Issue:
we had faced issue where we unfortunately locked the admin user on Netezza and unable to conenct to NZSQL,NZADMIN and even aginity work bench.
User wrongly updated the system table .
update _t_user set uselocked=TRUE where usename='ADMIN';
because of the above admin user locked out and its throwing the error "access denied".
SYSTEM.ADMIN(ADMIN)=> select uselocked from _t_user where USEname='ADMIN1';
USELOCKED
-----------
t
(1 row)
Solution:
we have special command to reset the admin user and it worked.
nzsql -admin -c "alter user admin reset account" ;
SYSTEM.ADMIN(ADMIN)=> select uselocked from _t_user where USEname='ADMIN1';
USELOCKED
-----------
f
(1 row)
we had faced issue where we unfortunately locked the admin user on Netezza and unable to conenct to NZSQL,NZADMIN and even aginity work bench.
User wrongly updated the system table .
update _t_user set uselocked=TRUE where usename='ADMIN';
because of the above admin user locked out and its throwing the error "access denied".
SYSTEM.ADMIN(ADMIN)=> select uselocked from _t_user where USEname='ADMIN1';
USELOCKED
-----------
t
(1 row)
Solution:
we have special command to reset the admin user and it worked.
nzsql -admin -c "alter user admin reset account" ;
SYSTEM.ADMIN(ADMIN)=> select uselocked from _t_user where USEname='ADMIN1';
USELOCKED
-----------
f
(1 row)
