Hi all,
11.2.0.1
aix6
Our database end-users like scott/tiger needs to change database password every month without loging in to sqlplus.
So they will enter the userid/password on a data-entry form like in apex where it stored in a table, example:
Then the user will click and update button to execute the change password command.
How do I create a script that will changa a db user password using an input table?
For example:
alter user scott identified by (select password from paswd_tbl where userid='SCOTT'); ???
Thanks a lot,
pK