Solved

SQL Server login practice

Posted on 2015-01-10
2
279 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 34

Author Closing Comment

by:Mike Eghtebas
ID: 40543208
Thank you.
0

Featured Post

Backup Solution for AWS

Read about how CloudBerry Backup fully integrates your backups with Amazon S3 and Amazon Glacier to provide military-grade encryption and dramatically cut storage costs on any platform.

Question has a verified solution.

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

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

726 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