Change Password without ALTER USER

From: <john_pickup_at_my-deja.com>
Date: Tue, 16 Nov 1999 16:31:29 GMT
Message-ID: <80s0t2$60m$1@nnrp1.deja.com>

Database: Oracle 8.0.4 Enterprise on NT

I have a number of applications that connect to an oracle database, some web-based others NT apps. All connect via Net8.

Users of these applications are able to change their oracle passwords and in all cases the underlying code executes:

ALTER USER <user> IDENTIFIED BY <new-pwd>

This works but unfortunately doesn't respect profile settings. In particular I am setting the password_reuse_max for the user's profile but this seems to be ignored when using ALTER USER.

Is there a correct way of changing a password that respects profile settings?

Thanks,
John.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 16 1999 - 10:31:29 CST