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

advertisements

_____________________________________________________________________________________________________________________

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