Insufficient Privileges To Execute Dbms_ddl.set_trigger_firing_property
(Doc ID 1923158.1)
Last updated on FEBRUARY 06, 2020
Applies to:Oracle GoldenGate - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
I am attempting to use dbms_ddl.set_trigger_firing_property in REPLICAT to delay triggers.
In my Replicat process prm file i have:
UserId <username>@<name>, Password <password>
SQLEXEC "begin dbms_ddl.set_trigger_firing_property('snoc', 'schedulable_resource_UP', FALSE); end; "
I have granted the following to the user:
GRANT EXECUTE on DBMS_DDL to <username>
When I start the replicat process I get the errors:
ERROR OGG-00891 Unsuccessful execution: Database error 1031 (ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_DDL", line 361
ORA-06512: at line 1 SQL begin dbms_ddl.set_trigger_firing_property('snoc', 'schedulable_resource_UP', FALSE); end; ).
On the web I found a site that said to enclose the trigger name in double quotes:
SQLEXEC "begin dbms_ddl.set_trigger_firing_property('snoc', '"schedulable_resource_UP"', FALSE); end; "
But that resulted in the error:
ERROR OGG-00206 Invalid SQLEXEC specification.
In the installation guide it states to run:
I did but still get the insufficient privileges error
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document