0 - 2 of 2 tags for grant option
Grants needed for a trigger

A Delete trigger on table T1 is intended to populate an audit table T1_Audit, but the insert fails with a 3523.  Here are the gory details;

 

CREATE MULTISET TABLE DEV_DB.T1 ,NO FALLBACK ,

     NO BEFORE JOURNAL,

     NO AFTER JOURNAL,

     CHECKSUM = DEFAULT,

     DEFAULT MERGEBLOCKRATIO

     (

By I_Luv_SQL, 19 Sep 2014 | Tagged: trigger grant option 3523 | 2 comments
Error 3523 - An owner referenced by user does not have EXECUTE PROCEDURE access

Hi,

By gpolanch, 19 Jul 2012 | Tagged: 3523 execute procedure grant option error 3523 | 4 comments