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

_____________________________________________________________________________________________________________________



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?

_____________________________________________________________________________________________________________________

0 comments:

Post a Comment

 

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