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 'alter trigger sys.dbt_logon enable';
end;
/
create or replace sys.disable_trigg_proc is
begin
execute immediate 'alter trigger sys.dbt_logon disable';
end;
/
create synonym your_favorite_user.enable_trigg_proc for sys.enable_trigg_proc
/
grant execute on sys.enable_trigg_proc to your_favorite_user
/
create synonym your_favorite_user.disable_trigg_proc for sys.enable_trigg_proc
/
grant execute on sys.disable_trigg_proc to your_favorite_user
/
I perfer this to granting privileges ...
Let me know if this will work for you.
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: Friday, March 07, 2003 10:14 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: What privs are required to alter a trigger owned by SYS?
Yes but do you have an answer to original question
********************************************************************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.*********************************************************************2
