C:\Users\at0022533>sqlplus hr@ORCL SQL*Plus: Release 22.214.171.124.0 Production on Fri Aug 26 13:30:12 2011 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter password: Connected to: Oracle Database 11g Enterprise Edition Release 126.96.36.199.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL>
What you are trying to achieve here? If someone can login into the database and he/she knows the password then what you will achieve by restricting to change the password?2) As we know that any user can change their password, I want to revoke this privlege from all the users and only DBA can change their password, how it can be done?