Smart Refresh

Thomas Speck · Post by **Thomas Speck** » Tue 21 Dec 2004 10:58

When I set SmartRefresh of TSmartQuery to "TRUE", the following Dialog-Box pops up:

Please execute GRANT EXECUTE ON DBMS_ALERT TO xxx on SYS
ORA-06550: line 2, column 3:
PLS-00201: identifier 'SYS.DBMS_ALERT' must be declared
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored

Is this by Design or is this a Fault ?

We use ODAC 5.50.0.14 Beta.

Alex · Post by **Alex** » Tue 21 Dec 2004 15:54

SmartRefresh feature uses DBMS_ALERT package, the user account must have EXECUTE privilege for this package. You must grant this privilege explicitly, by executing GRANT EXECUTE ON DBMS_ALERT TO UserName under SYS user.