Re: Does anyone have a program to change passwords?

Hi Keith,

    Write a sqlplus script that accepts the users new password as a parameter. It would look something like:

    alter user &1 identified by &2;
    exit

In effect you would be allowing the user to execute a sqlplus query without granting general access to sqlplus.

regards

Jerry Gitomer

Keith Shave wrote in message <3754099a.12707090_at_news.mb.sympatico.ca>...
>I'm migrating to Oracle 8i soon and I would like to take advantage of
>the advanced security options (password aging, history, etc.).
>
>I'm interested in hearing what anybody has done to allow the users to
>change their passwords once they do expire (with a grace period). I
>understand that Oracle has no tool and I don't believe it is in their
>plans to create one anytime soon.
>
>Giving the users access to use sqlplus is not a solution for me.
>
>Any hints, comments, experiences would be welcome. Thanks.
>
Received on Thu Jun 03 1999 - 17:41:12 CEST