Well, I'm creating an app web with Cold Fusion, every time I debug my project in the browser I get this error:
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer] The SELECT permission was denied on the object 'users', database 'hotel', schema 'dbo'
I'm using a user called CFLogin
and I grant to him select permissions through this command in SQL Server:
USE hotel
GO
GRANT SELECT ON dbo.users TO CFLogin
Also I've executed the follows stored procedures to give roles to my user:
EXEC sp_addrolemember 'db_owner',CFLogin
EXEC sp_addrolemember 'db_datareader',CFLogin
EXEC sp_addrolemember 'db_accessadmin',CFLogin
But it always results in the same message: Select permission was denied on object...
I've even rebooted the service but nothing seems working at all.
What am I doing wrong?
Regards!