Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
psangeetha
Yak Posting Veteran
95 Posts |
Posted - 2010-07-21 : 10:16:22
|
Hi friends, I need some help to create an application role for the QA database and grant this role 'read only' on few tables for specific users. This users when they login via application, this role will be enabled. I created the application role on management studio as below:create APPLICATION ROLE test WITH PASSWORD ='password1' , DEFAULT_SCHEMA = dbo; When I try to set the approle, I get this error EXEC sp_setapprole 'test', 'password1'Msg 15161, Level 16, State 1, Procedure sp_setapprole, Line 46Cannot set application role 'test' because it does not exist or the password is incorrect. When I right click on the approle 'test' properties, and select a schema owned by this role, when I go back to the properties again the schema is checked but I'm not able to uncheck it and select a different schema.. Any suggestions please? I'm not sure if I'm doing this right.. I also searched in msdn to see if there is any step by step procedure to accomplish this but cant find it..Thanks much |
|
|
|
|