Monday, February 15, 2010

public role

Do you remember the public role in SQL Server?
Which of the following is NOT a valid description of the public role?

A. The public role captures all default permissions for users in a database.
B. The public role cannot be dropped.
C. The public role is contained in every database, including msdb, tempdb, model, and all user databases except in the master database for security purposes.
D. The public role cannot have users, groups, or roles assigned to it.

Answer:[C]
Highlight to find out the answer.

No comments:

Post a Comment