SYMPTOM:
A user runs a Strategy Report Services Document and the following error is recorded in the DSSerrors.log:
Sample Code/Error
(QueryEngine encountered error: Execute Query failed.
Error type: Odbc error. Odbc operation attempted: SQLExecDirect. The SELECT permission was denied on the object 'DATE', database 'XXX', schema 'YYY'. Connection String: DSN=XXX_DEV;UID=XXXX ;APP=Strategy 9.3 ® Common Files; SQL Statement: XXXXX
The following error is displayed to the user in Web:
WebIServerSessionImpl initAuthInfo MSIXML : Server "" not connected. (com.Strategy.web.objects.WebObjectsException)
CAUSE:
"The SELECT permission was denied" indicates that the user account accessing the database does not have SELECT permissions for the required table/object.
ACTION:
The Database Administrator must ensure that the user account accessing the database has SELECT permissions for the table involved in the report. Alternatively, a user account having those permission may be used for warehouse access and this should be updated in the Developer (Database Instance > Database Connection > Database Login).
