Error on execution of OracleTableDependency

Jan 12, 2016 at 1:17 PM

i have a problema on the execution of OracleTableDependency, it shows the next error:

User with no EXECUTE permission on DBMS_AQADM or DBMS_AQ package or DBMS_SCHEDULER.

What is it? how i can repair it?

any help is welcome and apreciate.

Jan 13, 2016 at 6:51 PM
Hi. Sorry for this late response.

The exception you received, is thrown by OracleTableDependency, because the user specified in your connection string, has no

DBMS_AQ package or


These permissions are needed because OracleTableDependency create a JOB on Oracle, in order to monitor the queue usage and destroy it when it is not used anymore. So, in order to use OracleTableDependency, the User Id specified in <connectionStrings> must be granted correclty:
    <add name="OracleConnectionString"
        connectionString="Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST= 1521)))(CONNECT_DATA=(SERVICE_NAME = XE)));User Id=SYSTEM;password=tiger;"
If you need other help, do not hesitate to contact me.

Jan 14, 2016 at 2:26 PM
already i have working my code ( DBA is a nice guy :) )

thank you delbianco.