Privilege granting or revocation for users in password-invalid account lock state

Nonstop Database, HiRDB Version 9 System Operation Guide

25.6 Privilege granting or revocation for users in password-invalid account lock state

Organization of this section: (1) Granting privileges to users in password-invalid account lock state; (2) Deleting privileges from users in password-invalid account lock state

(1) Granting privileges to users in password-invalid account lock state

The DBA privilege cannot be granted to a user (who has the CONNECT privilege) who is in password-invalid account lock status. You must first release the user from password-invalid account lock state, then you can grant the DBA privilege.

(2) Deleting privileges from users in password-invalid account lock state

You use a REVOKE statement to revoke privileges from users in password-invalid account lock state.