Tuesday, August 30, 2022

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

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.

Cause

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


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.

References

No comments:

Post a Comment

Search This Blog