Problem with Application Role

[antzzz]

I created one application role named "AppUser" and gave it Select access to one table named "Parameters". I also created one stored procedure "Get_Params" with "select * from Parameters"; I also gave the above role execute permission for this sp. I used one database login with sysadmin privileges to connect to SQL SERVER and then I execute sp_setapprole to activate the application role. When I try to create a recordset with strsql = "Get_Params", I'm given an error message saying that it can't find the stored procedure. I also tried the normal select statement and I'm given a "syntax error or access violation error" message. I'm sure application roles are easy to use but why am I being given these problems? Please help! I checked the for the existence of both the Parameters table and the Get_Params sp and they both exist with permissions for my App Role. Thanks

 

[TomSark]

What is the owner of the proc and the table? Tom Davis
tdavis@sark.com

http://www.sarkdallas.com

 

[antzzz]

Thanks for your reply. The owner of both objects is the same user I used to create the app role, the table, and the sp. Using EM, I gave permissions to this approle on both objects. Hope you can help!