Application Role question

[DeveloperJr]

I created an aplication role and made it DataReader and DataWriter, when I set the application role using sp_setapprole and I try to select from a table in the database, I get The SELECT permission was denied on the object <table name> <database name> schema 'dbo'.

Any thoughts?

 

[mrdenny]

I'm not sure if you can add an application role to a database role for granting permissions. Try granting permissions directly to the role.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com