About this task
To reset a locked account, complete the following steps:
Procedure
- Log in to the SYSTEM database as the admin user or any database user who
is granted Alter privilege on User objects or the locked user account.
Note: If you created an administrative user group, as described in
Creating an administrative user group, you can log in as any database user
who is a member of that group to unlock the user account.
- Use the ALTER USER RESET ACCOUNT command:
SYSTEM.ADMIN(ADMIN)=> ALTER USER username RESET ACCOUNT
Results
If the admin user is locked, you can unlock it by using one
of the administrative group of users. If you do not have any users
who are granted Alter privileges on user objects or the admin account,
contact Netezza Performance Server Support
to unlock the admin account.