| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Privileges on Triggers
Bill,
I don't understand the purpose of doing this. A trigger fires whenever its triggering condition occurs. If a user has the privileges to cause the triggering condition (e.g., insert, update, delete) then the trigger will run.
Paul Baumgartel
CREDIT SUISSE
Information Technology
Securities Processing Databases Americas
One Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel_at_credit-suisse.com
www.credit-suisse.com
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of William Wagman
Sent: Thursday, November 01, 2007 4:13 PM
To: oracle-l
Subject: Privileges on Triggers
Greetings,
I have been playing around trying to grant execute on a trigger to a particular user. After playing with this for a while and reading docs I have come to the conclusion that execute on a trigger is not an allowed grant. Instead the access is given via a public synonym. For example, give the particular trigger, usera.trigger. If usera wants to allow userb to use the trigger it is sufficient merely to create a public synonym, create public synonym trigger on usera.trigger and user b will then be able to use the trigger. Seems to simplistic for me, is that correct or am I missing something?
Thanks.
Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman_at_ucdavis.edu
(530) 754-6208
--
http://www.freelists.org/webpage/oracle-l
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 01 2007 - 16:18:20 CDT
 |
 |