Above three are the most important concepts related to security and SQL Server. There are many more things one has to learn but without beginners fundamentals one can’t learn the advanced concepts. Let us have small quiz and check how many of you get the fundamentals right.

Quiz

1) If you granted Phil control to the server, but denied his ability to create databases, what would his effective permissions be?

Phil can do everything.

Phil can do nothing.

Phil can do everything except create databases.

2) If you granted Phil control to the server and revoked his ability to create databases, what would his effective permissions be?

Phil can do everything.

Phil can do nothing.

Phil can do everything except create databases.

3) You have a login named James who has Control Server permission. You want to elimintate his ability to create databases without affecting any other permissions. What SQL statement would you use?

ALTER LOGIN James DISABLE

DROP LOGIN James

DENY CREATE DATABASE To James

REVOKE CREATE DATABASE To James

GRANT CREATE DATABASE To James

Now make sure that you write down all the answers on the piece of paper.

Watch following video and read earlier article over here. If you want to change the answer you still have chance.

Solution

1) 3

2) 1

3) 3

Now compare let us check the answers and compare your answers to following answers. I am very confident you will get them correct.

Community Initiatives

About Pinal Dave

Pinal Dave is a Pluralsight Developer Evangelist. He has authored 11 SQL Server database books, 17 Pluralsight courses and have written over 3200 articles on the database technology on his blog at a http://blog.sqlauthority.com. Along with 11+ years of hands on experience he holds a Masters of Science degree and a number of certifications, including MCTS, MCDBA and MCAD (.NET). His past work experiences include Technology Evangelist at Microsoft and Sr. Consultant at SolidQ. Follow @pinaldave
Send Author Pinal Dave
an email at pinal@sqlauthority.com

Email Subscription

Enter your email address to subscribe to this blog and receive notifications of new posts by email.