Subject: RE: Privileges on Triggers 2007-11-01 - By Baumgartel, Paul
Back
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@(protected)
www.credit-suisse.com
-- --Original Message-- --
From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)] 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@(protected)
(530) 754-6208
--
http://www.freelists.org/webpage/oracle-l
==============================================================================
Please access the attached hyperlink for an important electronic communications
disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================
--
http://www.freelists.org/webpage/oracle-l
|
|
