RE: What privs are required to alter a trigger owned by SYS?

Yes but do you have an answer to original question Jamadagni,

RE: What privs are required to alter a trigger owned by SYS?

Title: RE: What privs are required to alter a trigger owned by SYS? Rick, My 2000 crashed yesterday and I lost my reply to you, so here it is ... alter any trigger is the privilege ... but here is a better solution ... create or replace sys.enable_trigg_proc is begin execute immediate

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 -- Please see the

RE: What privs are required to alter a trigger owned by SYS?

Title: RE: What privs are required to alter a trigger owned by SYS? 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