Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

What is the difference between these two "Connect SQL" permissions in SQL Server 2012?

enter image description here

share|improve this question

1 Answer 1

While I can't be certain because you blanked out the Grantor I think you will find that the rows have a different entry in that column. It is possible to have multiple entries of a permission in that list if the individual who granted the permission is different.

share|improve this answer
    
The Grantor for the unchecked column (and all other ones) is empty, except the Grantor for the checked column, which is the SA account (which is disabled). Does this simply mean that this account can connect to SQL (through the SA grant) and what does Connect SQL permission without grantor mean in this context? Thanks! –  Alex Jan 20 at 7:28
    
The grantor really has no effect on the permission. That account can connect to SQL regardless of the fact that it was granted by 2 different individuals, who they are and whether or not they are active. My guess is that the grantor column is blank because the login that granted the permission no longer exists. –  Kenneth Fisher Jan 20 at 13:37

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.