Simplifying security on SQL Server 2008 R2.
Posted on 2011-03-25
I'm using SQL Server 2008 R2 (it's the Dev Ed on my Dev Svr).
I have a DB which is under development.
I use Windows Authentication.
I want to allow all users access to the stored procedures and views for the DB.
What is the simplest way to do this please?
I have the sysadmin role (only because I am the developer on the dev svr - not really a proper admin) and I've manually allowed one other user access to the SPs (ticking the execute option for the SPs for that user). I don't have any views yet.
I know I can do this for each user, but I'm quite happy to simply allow all authenticated users access. The app is both an Excel spreadsheet and a PHP developed web app.
When I add new SPs and views, can these inherit the permissions? Or do I need to add a security setting.