Hi,

> > > > How can I grant a user the right to modify a trigger (active -->
>inactive,
> > > > inactive --> active)?
> > >That's a DDL change. DDL changes rights are inaffected by SQL Grants.
> > ok so there's no way for a non-sysdba user to make such a change?
>
>As far as I know, only SYSDBA and the object owner (the user who created
>the object) can alter the object.
>
> > >Why do you want to change it anyway
> > It was part of a design but now that I think about it again it doesn't
>make
> > any sense. So I will just do without it.
>
>Not just any user should do DDL changes... If you need these kind of
>changes,
>on a daily basis, there's obviously something wrong...

I see that now, thanks for the info.

Bert