Error on execution of OracleTableDependency

Jan 12, 2016 at 1:17 PM
Hello.

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.

thanks
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_AQADM or
DBMS_AQ package or
DBMS_SCHEDULER

permissions.

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:
<connectionStrings>
    <add name="OracleConnectionString"
        connectionString="Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT= 1521)))(CONNECT_DATA=(SERVICE_NAME = XE)));User Id=SYSTEM;password=tiger;"
        providerName="Oracle.DataAccess.Client"/>
</connectionStrings>
If you need other help, do not hesitate to contact me.

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

thank you delbianco.