Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Can I stop someone changing their password ?
Norman Dunbar wrote:
>
> Strange question time again :
>
> Server : Solaris 7
> Oracle : 8.1.7.2.0
>
> A fellow DBA has a problem on her site, she has a user which has to have
> a specific password - she inherited an application set up in this way
> and cannot change it unfortunately.
>
> All the users - who have their own OPS$ users - know the password and
> none of them have alter user privs, neither does the actual user in
> question.
>
> Someone is changing the password for the application user. This causes
> the client apps to fall over as they can no longer connect. Auditing is
> turned on, and she is auditing alter user, however, it appears that
> there are ways and means to change the password without using alter user
> - 'password' for example and this cannot be audited. She has spoken to
> Oracle and they appear to be stumped at the moment.
>
> I've looked at profiles, but they have lots of options to force a
> password change, but nothing to stop it from being done.
>
> Anyone had this problem before and/or knows how to stop it, or at least
> help us identify the 'poor misguided creature' who insists on changing
> the password ?
>
> Much obliged for any information.
>
> Rehards,
> Norman.
>
> ------------------------------------------------------------------------
> -----
> Norman Dunbar EMail: Norman.Dunbar_at_LFS.co.uk
> Database/Unix administrator Phone: 0113 289 6265
> Fax: 0113 289 3146
> Lynx Financial Systems Ltd. URL: http://www.Lynx-FS.com
> ------------------------------------------------------------------------
> -----
Add a password verification function which only allows new and old password to be the same..
hth
connor
-- ============================== Connor McDonald http://www.oracledba.co.uk "Some days you're the pigeon, some days you're the statue..."Received on Thu Jan 24 2002 - 14:32:20 CST