Thursday, June 5, 2014

How to lock Netezza userid

How do you lock Netezza userid?  You actually cannot find any way from NZ Admin tool or Aginity or even from the portal.  Then, how do you lock a Netezza userid?  Below command will show you:


SYSTEM(ADMIN)=> update _t_user set uselocked=true where usename='TEST1';  
UPDATE 1  


If you want to unlock, you can use NZ Admin tool.

No comments:

Post a Comment