Re: Unchangeable passwords?

From: Carl Gohringer <cgohring_at_lucifer>
Date: Mon, 23 May 1994 16:36:51 GMT
Message-ID: <1994May23.163651.23684_at_oracle.us.oracle.com>


Actually, let me correct myself before somebody else does it for me.

There is no way to tell the database to prevent a user from changing their password.
However, using PRODUCT_USER_PROFILE, you can restrict certain users from using certain commands from SQL*Plus.

Since 99.9% of users will change their passwords through SQL*Plus, you can simply use PRODUCT_USER_PROFILE to tell SQL*Plus not to allow particular users to use the ALTER USER command through SQL*Plus.

Of course, a really determined user could write a PRO*C program to issue the ALTER USER command and change their password.

For more info on PRODUCT_USER_PROFILE, consult the SQL*Plus Reference Manual.

regards,
Carl
+-----------------------------------------------------------------------------+
Carl Gohringer, Senior CASE Support Consultant Oracle UK, The Oracle Centre, The Ring, Bracknell, Berkshire, England, RG121BW  

Internet : cgohring_at_uk.oracle.com
+-----------------------------------------------------------------------------+
Received on Mon May 23 1994 - 18:36:51 CEST

Original text of this message