Reports Integration Guide › Troubleshooting › Reports: Problems running BusinessObjects Reports for CA Data Protection › An Individual Reviewer Sees An Error Message When Running A Report From InfoView

An Individual Reviewer Sees An Error Message When Running A Report From InfoView

Symptom:

An iConsole reviewer sees the following error message when they run a BusinessObjects report for CA Data Protection directly through Infoview (not after launching InfoView from the iConsole):

The SELECT permission was denied to the object <tablename> database <databasename>

Solution:

The most likely reason is that the BusinessObjects user account is not associated with any CA Data Protection user account. Therefore the BusinessObjects user does not have rights to see CA Data Protection data.

A BusinessObjects 'Administrator' account may see this error because the CA Data Protection ‘Administrator’ account is usually associated with a less privileged BusinessObjects ‘CADLPBOAdmin’ account. This account association ensures that the CA Data Protection administrator does not have administrative rights against aspects of BusinessObjects that are not related to CA Data Protection.