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?
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google