GPS Error: 68 SQL Error: 229 SELECT permission denied on object

22 December 2003

Issue Description

When attempting to run an object that is based on a view, the following error occurs:
GPS Error: 68

When 'OK' is selected, the following error dialog appears:
SQL Error: 229 [Microsoft][ODBC SQL Server Driver][SQL Server] SELECT permission denied on object 'object name' database 'database ID', owner 'dbo'

When 'OK' is selected, the following error dialog appears:
ODBC Error: 42000

Solution

When you create a SQL view to be imported with AnyView External Table Wizard, you must grant select access to DYNGRP.

Grant select access to DYNGRP in one of the two following ways:

  1. Add the following line to the SQL View script -
    GRANT SELECT ON [dbo].[view name] TO [DYNGRP]
    GO
  2. Grant permissions in Enterprise Manager
    1. Launch Enterprise Manager.
    2. Expand a server group, and then expand a server.
    3. Expand Databases, and then expand the database to which the object belongs.
    4. click 'Views'
    5. In the details pane, right-click the object on which to grant permissions, point to All Tasks, and then click Manage Permissions.
    6. Click List all users/user-defined database roles/public, and then select at least 'SELECT' access for the DYNGRP role. A check indicates a granted permission. Only permissions applicable to the object are listed.

Site Map