Alter User Identified By Values

  • Norbert Debes


ALTER USER username IDENTIFIED BY VALUES ‘password_hash’ is an undocumented SQL statement. It is used internally by import utilities to store a password hash, which was previously saved with an export utility, in the data dictionary base table SYS.USER$. In situations where a DBA needs to connect as a certain user, but does not or must not know the password of that user, the capability to restore a saved password hash saves time and spares the DBA from annoyance asking around for passwords.


Editing Bove Securit 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Norbert Debes 2009

Authors and Affiliations

  • Norbert Debes

There are no affiliations available

Personalised recommendations