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

• Which of the following is an invalid file name for a database file?
• You are loading 100 rows of data into a narrow table that is heavily used by your production inventory queries...
• Which key provides the strongest encryption?
• Can you give me an overview of some of the database objects available for use in SQL Server 2000?
• What does this method in SQL Server 2005's SMO equate to in T-SQL? db.CheckTables(RepairType.None)
• What does VARP() do in SQL Server 2005?
• What are triggers? What are the different types of triggers in SQL Server 2000?
• You are building a .NET assembly that will access the registry of the local machine for a factor used in a computer column. What permission set should you assign it?
• In SQL Server 2005, what permissions does a user need to successfully execute the USE command?
• Which type of XML variable requires a\one and only one root element?
• More...