SQL Server has a long list of roles for server, database, and applications that outline things like permissions, data selection and modification, and disk management. Examine how roles play a part in ...

I'm currently writing an SP to move all user assigned perms per database to a role. We are doing this to tidy up our security on our many databases.<BR><BR>I have written a script that works, however ...

Joel Snyder, Ph.D., is a senior IT consultant with 30 years of practice. An internationally recognized expert in the areas of security, messaging and networks, Dr. Snyder is a popular speaker and ...

How do I assign permissions to users to see SQL Agent Jobs? Your email has been sent You can give your users rights to check if reports have run or jobs are complete without granting full admin rights ...