Need to learn User administration
-
I am looking to learn how to administer users in SQL Sever 2012, such as permissions for views and tables as well as utilizing schemas to control user access to data.
Any suggestions of books or resources?
Thank you.
-
Books Online is always the place to start when learning about anything in SQL Server. When you're ready for the details, I can't recommend Denny Cherry's book on security strongly enough. But most of what you'll need is in the Books Online.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Thank you.
-
Y BOL is great. Denny's book doesn't really cover stuff like that. He's more concerned with the overall security of your enterprise. Excellent info, but not at the instance level as much.
I've also got some decent vids on midnightdba.com.
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARantMinion Maintenance is FREE:
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply