Error = [Microsoft][ODBC SQL Server Driver]SELECT permission denied on object 'object name',

23 December 2003

Issue Description

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.

Solution

Verify that ANYVIEWSA has been given db_reader and db_writer access to both the system and application database in SQL Enterprise Manager.

  1. Open SQL Enterprise Manager and navigate to the system database.
  2. Find the ANYVIEWSA user in the 'Users' directory, right-click on ANYVIEWSA and select 'Properties'.
  3. Verify that the both db_reader and db_writer are selected. Click 'OK'.
  4. Navigate to the application database.
  5. 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

Site Map