[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQL Server login practice

Posted on 2015-01-10
2
Medium Priority
?
291 Views
Last Modified: 2015-01-11
After reading and somewhat understanding security components (principals, securables, and permissions, fixed roles, user-defined roles, etc.), I like to get good skill by practicing them.

Question: Where can I find typical scenario statement to apply in my SQL Server installation and test them to make sure I have done correctly?

for example:
- make user1 sys admin
- make user2 database owner
- make few other users and assign them different roles
- assign roles
- process how to test them.

I can make my own examples; but most likely they may not be as good as thoughtfully designed by an experienced SQL Server admin.
0
Comment
Question by:Mike Eghtebas
2 Comments
 
LVL 51

Accepted Solution

by:
Mark Wills earned 2000 total points
ID: 40543158
Big question, and quite possible too difficult to provide general advice.

Having said that, there are resources via MS Books online that can provide insights and tips such as checklists : http://technet.microsoft.com/en-us/library/ff848786(v=sql.105).aspx and Best Practices whitepaper : http://download.microsoft.com/download/8/F/A/8FABACD7-803E-40FC-ADF8-355E7D218F4C/SQL_Server_2012_Security_Best_Practice_Whitepaper_Apr2012.docx

For a more opinionated "guide" have a read of : http://www.mssqltips.com/sqlservertip/3159/sql-server-security-checklist/ it presents the most common issues as a "do this" type checklist. But before you actually do those things, make sure you understand the ramifications and your own environment...

Once you have gained a clearer list of items that may need more insights, then we will probably be in a better position to address more specific scenarios.

Happy reading :)
0
 
LVL 34

Author Closing Comment

by:Mike Eghtebas
ID: 40543208
Thank you.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question