Subject | Re: [Firebird-Architect] Bulk loader. |
---|---|
Author | Roman Rokytskyy |
Post date | 2007-11-04T21:09:06Z |
>> Because the bulk insert command would bypass triggers, which isSorry, I cannot trace your ideas here, please elaborate.
>> something you don't want to allow everybody.
>>
>>
> That's true, but isn't that a general problem and not particularly
> specific to bulk insert.
> But while we're one the subject, wouldn't it be nice to be able disableWe could, but how do we prevent Joe from adding a
> triggers on a per-connection basis? Very easy to do and would be use in
> this case as well as many others.
isc_dpb_ignore_triggers to DPB and bypass the audit log triggers, and
allow Ann doing this for bulk load stuff?
> Oh, you don't need a privilege to disable triggers if you restrict it toNot sure that I want to merge those permissions... but you're right - a
> people with the right to drop the trigger. Kinda the same thing, really.
guy that has DROP permission on trigger does not need BULK INSERT
permission to disable trigger.
Roman