SQL SERVER – Quiz and Video – Introduction to SQL Server Security

This blog post is inspired from Beginning SQL Joes 2 Pros: The SQL Hands-On Guide for Beginners – SQL Exam Prep Series 70-433 – Volume 1.

[Amazon] | [Flipkart] | [Kindle] | [IndiaPlaza]

This is follow up blog post of my earlier blog post on the same subject – SQL SERVER – Introduction to SQL Server Security – A Primer. In the article we discussed various basics terminology of the security. The article further covers following important concepts of security.

  • Granting Permissions
  • Denying Permissions
  • Revoking Permissions

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?

  1. Phil can do everything.
  2. Phil can do nothing.
  3. 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?

  1. Phil can do everything.
  2. Phil can do nothing.
  3. 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?

  1. ALTER LOGIN James DISABLE
  2. DROP LOGIN James
  3. DENY CREATE DATABASE To James
  4. REVOKE CREATE DATABASE To James
  5. 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.

SQL SERVER - Quiz and Video - Introduction to SQL Server Security combos

Available at

USA: Amazon

India: Flipkart | IndiaPlaza

Volume: 1, 2, 3, 4, 5

Please leave your feedback in the comment area for the quiz and video. Did you know all the answers of the quiz?

Reference: Pinal Dave (https://blog.sqlauthority.com)

Joes 2 Pros
Previous Post
SQL SERVER – Four Tutorial for SQL Server 2012 New Features
Next Post
SQL SERVER – Quiz and Video – Introduction to Basics of a Query Hint

Related Posts

Leave a Reply