2 added 4 characters in body
source | link

Turned out to be my database user - it was missing db_datareader & db_datawriter roles from its Database role membership so was being denied the SELECT permission.

I discovered this by setting logging to DEBUG in logback.xml and the following errors appeared in my cd_core log:

2014-01-08 13:42:07,143 DEBUG JDBCExceptionReporter - could not execute update query [delete from DYNAMIC_LINKS where SRC_PUB_ID=? and SRC_ITEM_ID=? and SRC_ITEM_TYPE=?]
com.microsoft.sqlserver.jdbc.SQLServerException: The SELECT permission was denied on the object 'DYNAMIC_LINKS', database 'Tridion_Broker', schema 'dbo'.

Turned out to be my database user - it was missing db_datareader & db_datawriter roles from its Database role membership so was being denied the SELECT permission.

I discovered this by setting logging to DEBUG in logback.xml and the following errors appeared in my cd_core:

2014-01-08 13:42:07,143 DEBUG JDBCExceptionReporter - could not execute update query [delete from DYNAMIC_LINKS where SRC_PUB_ID=? and SRC_ITEM_ID=? and SRC_ITEM_TYPE=?]
com.microsoft.sqlserver.jdbc.SQLServerException: The SELECT permission was denied on the object 'DYNAMIC_LINKS', database 'Tridion_Broker', schema 'dbo'.

Turned out to be my database user - it was missing db_datareader & db_datawriter roles from its Database role membership so was being denied the SELECT permission.

I discovered this by setting logging to DEBUG in logback.xml and the following errors appeared in my cd_core log:

2014-01-08 13:42:07,143 DEBUG JDBCExceptionReporter - could not execute update query [delete from DYNAMIC_LINKS where SRC_PUB_ID=? and SRC_ITEM_ID=? and SRC_ITEM_TYPE=?]
com.microsoft.sqlserver.jdbc.SQLServerException: The SELECT permission was denied on the object 'DYNAMIC_LINKS', database 'Tridion_Broker', schema 'dbo'.
1
source | link

Turned out to be my database user - it was missing db_datareader & db_datawriter roles from its Database role membership so was being denied the SELECT permission.

I discovered this by setting logging to DEBUG in logback.xml and the following errors appeared in my cd_core:

2014-01-08 13:42:07,143 DEBUG JDBCExceptionReporter - could not execute update query [delete from DYNAMIC_LINKS where SRC_PUB_ID=? and SRC_ITEM_ID=? and SRC_ITEM_TYPE=?]
com.microsoft.sqlserver.jdbc.SQLServerException: The SELECT permission was denied on the object 'DYNAMIC_LINKS', database 'Tridion_Broker', schema 'dbo'.