Subject Re: [ib-support] rights to modify a trigger.
Author Martijn Tonies

> > > 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...

Good luck,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird

Upscene Productions

"This is an object-oriented system.
If we change anything, the users object."