Hi,

I'm traing to inactivate a trigger from a normal user
account(non-SYSDBA).
with:

ALTER trigger AI_MYTABLE_IDMYTABLE inactive;

And I receive an error message...

MODIFY TRIGGER failed.
no permission for control access to TABLE MYTABLE.

My user has all rights(INSERT,UPDATE,DELETE,REFERENCE)
on table MYTABLE and work fine in all situations but
in this particular case not.

Can someone help me?


Corneliu T.

=====


__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com