I'd rather own that trigger by someone other than *sys* ...
Raj
-------------------------------------------------------------
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !!
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 06, 2003 2:39 PM
To: Multiple recipients of list ORACLE-L
Subject: What privs are required to alter a trigger owned by SYS?
Hi all,
I have trigger owned by sys. It is actually an after login trigger. I want
certain users to be able to enable/disable this trigger. What privs are
required?
I have tried alter any trigger and I still get insufficient privs when
trying to enable trigger.
Thanks
Rick
*********************************************************************This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*********************************************************************1
