Solved

SQL Server login practice

Posted on 2015-01-10
2
272 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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
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.

743 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

11 Experts available now in Live!

Get 1:1 Help Now