DBA > Job Interview Questions > Microsoft SQL Server FAQs

What is the scope of the control permission in S

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is the scope of the control permission in SQL Server 2005?

Answer
It allows the grantee the equivalent of ownership in that they have all permissions and can grant them to others.
Explanation
The Control permission is equivalent to assigning ownership of the securables. All available permissions are granted to the principal, and they the principal in turn can grant those permissions to others.

(Continued on next question...)

Other Job Interview Questions