SyntaxFix

[sql-server] The SELECT permission was denied on the object 'Users', database 'XXX', schema 'dbo'

Using SSMS, I made sure the user had connect permissions on both the database and ReportServer.

On the specific database being queried, under properties, I mapped their credentials and enabled datareader and public permissions. Also, as others have stated-I made sure there were no denyread/denywrite boxes selected.

I did not want to enable db ownership when for their reports since they only needed to have select permissions.

Examples related to sql-server

• Passing multiple values for same variable in stored procedure • SQL permissions for roles • Count the Number of Tables in a SQL Server Database • Visual Studio 2017 does not have Business Intelligence Integration Services/Projects • ALTER TABLE DROP COLUMN failed because one or more objects access this column • Create Local SQL Server database • How to create temp table using Create statement in SQL Server? • SQL Query Where Date = Today Minus 7 Days • How do I pass a list as a parameter in a stored procedure? • SQL Server date format yyyymmdd

Examples related to azure-sql-database

• How to view the roles and permissions granted to any database user in Azure SQL server instance? • Azure SQL Database "DTU percentage" metric • Reset identity seed after deleting records in SQL Server • How to re-create database for Entity Framework? • The SELECT permission was denied on the object 'Users', database 'XXX', schema 'dbo' • How do I create a new user in a SQL Azure database? • How to emulate a BEFORE INSERT trigger in T-SQL / SQL Server for super/subtype (Inheritance) entities? • Optimal way to concatenate/aggregate strings • How do I copy SQL Azure database to my local development server?