Error = [Microsoft][ODBC SQL Server Driver]SELECT permission denied on object 'object name',
23 December 2003
While logged in as "SYSADMIN" and attempting to view an Explorer object, the following error message is displayed:
Error = [Microsoft][ODBC SQL Server Driver]SELECT permission denied on object 'object name', database 'database name', owner 'dbo'. [Microsoft][ODBC SQL Server Driver][SQL Server]The cursor was not declared.
The SQL Server Database Role has not been properly set for ANYVIEWSA on the system and/or application database. A database role does not control administrative access to an Analysis Services object; instead it determines read and write capabilities when a user is connected to an Analysis Services database through a client application.
Verify that ANYVIEWSA has been given db_reader and db_writer access to both the system and application database in SQL Enterprise Manager.
- Open SQL Enterprise Manager and navigate to the system database.
- Find the ANYVIEWSA user in the 'Users' directory, right-click on ANYVIEWSA and select 'Properties'.
- Verify that the both db_reader and db_writer are selected. Click 'OK'.
- Navigate to the application database.
- Repeat steps b and c.
If this does not resolve the issue, please contact the Accountable Software Technical Support Team.
Phone: 484-875-0600 ext. 9
Email: Accountable Software Technical Support Team