Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. -2147217911 - [Microsoft][ODBC SQL Server Driver][SQL Server]SELECT permission denied on object 'Table_Name', database 'Database_Name', owner 'dbo'.

-2147217911 - [Microsoft][ODBC SQL Server Driver][SQL Server]SELECT permission denied on object 'Table_Name', database 'Database_Name', owner 'dbo'.

Symptoms

---------------------------
FRx Reporting Engine
---------------------------
-2147217911 - [Microsoft][ODBC SQL Server Driver][SQL Server]SELECT permission denied on object 'Table_Name', database 'Database_Name', owner 'dbo'.
---------------------------
OK Cancel
---------------------------

This error occurs when generating a report.

↑ Back to the top

Cause

The user's database login has not been granted the db_datareader role for the database.


↑ Back to the top

Resolution

Grant the user's Microsoft SQL Server login access to the database(s) for which they are generating reports and give them the db_datareader fixed database role.

↑ Back to the top

References

↑ Back to the top

Keywords: kb

↑ Back to the top

Article Info
Article ID : 963994
Revision : 5
Created on : 8/19/2020
Published on : 8/20/2020
Exists online : False
Views : 66