Re: Unchangeable passwords?
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