Solved

SQL Server login practice

Posted on 2015-01-10
2
276 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 500 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 33

Author Closing Comment

by:Mike Eghtebas
ID: 40543208
Thank you.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

910 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now