Re: CHANGE PASSWORD

From: Michael Ringbo <mri_at_dde-nospam.dk>
Date: Wed, 24 Feb 1999 11:39:11 +0100
Message-ID: <36D3D6CF.6B50E17@dde-nospam.dk>

Hi,

If your users are to use a Forms 4.5 / 5.0 application, and have to have the ability to change their own password there is a way to dot this without having to grant them ALTER USER directly: 1) Make a role with the ALTER USER privilege. Make the role password-protected.
2) Grant the role to the users. Be sure it won't be their default role 3) Set the role from within your apllication using forms_ddl

I have done this with a Forms application, but I don't know if you could use this method using other application platforms.

Miguel Almeida wrote:

> How can i prevent a user, with ALTER USER system privilege, to change SYS
> password?
Received on Wed Feb 24 1999 - 04:39:11 CST