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

Good luck,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

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