Subject Re: [ib-support] rights to modify a trigger.
Author Bert Neef

> > > > How can I grant a user the right to modify a trigger (active -->
> > > > 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
> > any sense. So I will just do without it.
>Not just any user should do DDL changes... If you need these kind of
>on a daily basis, there's obviously something wrong...
I see that now, thanks for the info.