Re: how to stop user from altering schema

nitin_kaul_at_rediffmail.com wrote:
> hi all
>
> I have a user on prod db..which has got no create privs...
>
> But the user can alter the objects in its own schema.
>
> Is there any way by which i can stop it.
>
> regards
>

CREATE OR REPLACE TRIGGER no_alter
BEFORE ALTER
ON SCHEMA DECLARE BEGIN
   RAISE_APPLICATION_ERROR(-20998, 'You Are Not Allowed To Alter This Schema');
END no_alter;
/

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)