Trick to HIDE / Mask Oracle User Password in Alter User Command?

_____________________________________________________________________________________________________________________

The Eucharistic Miracles of the World


Generally we give the password in alter user command which will be visible to others. But, in case you don’t want show the password while changing it you can use the accept SQL*PLUS command with hide option.

See the example below.

SQL> accept username prompt "Enter User:"
Enter User:scott
SQL> accept password prompt "Enter New Password:" hide
Enter New Password:
SQL> alter user &username identified by &password;

User altered.

How is it? Helpful?

_____________________________________________________________________________________________________________________

Website Stats

0 comments:

Post a Comment

Labels

Oracle (578) General (60) Unix (47) Script (41) Blog (23) OCI (3) SQL* Loader (3) Datapump (2) Software (1)
DBA Tips
 

acehints.com Copyright 2011-21 All Rights Reserved | Site Map | Contact | Disclaimer