Re: CHANGE PASSWORD

From: Jurij Modic <jmodic_at_src.si>
Date: Tue, 23 Feb 1999 22:03:27 GMT
Message-ID: <36d32063.7072629@news.siol.net>

On Tue, 23 Feb 1999 13:29:29 -0000, "Miguel Almeida" <jmiguel_at_cet.pt> wrote:

>How can i prevent a user, with ALTER USER system privilege, to change SYS
>password?

You can't! Revoke ALTER USER from them if you can't trust them, that is all you can do.

I would give this privilege only to DBAs, and I would have to trust them that they know what they are doing, otherwise they wouldn't be given the DBA privileges in the first place.

HTH,
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Tue Feb 23 1999 - 16:03:27 CST