I don't think any Server roles are needed, but "db_datareader" Database role should provide the SELECT permissions. I'm not sure about the permissions for stored procedures.
Carl >Kinda.. Are there any particular SERVER ROLES or Database Role Membership? > >Thanks! > >GRANT SELECT >GRANT EXECUTE > >Is that what you are looking for? > >-Mike Chabot > >On Thu, Nov 18, 2010 at 11:32 AM, Brian Polackoff <bpolack...@gmx.com> >wrote: >> >> I admit this question is a touch off topic, but the SQL list is not >> nearly as active. Can anyone tell me what the minimum MS SQL server >> 2005 security settings to run SELECT and Execute Existing Stored >Procedures? >> >> My googling has failed me. (it was bound to happen eventually) >> >> Thanks! >> Brian ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339354 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
