HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Two "Connect SQL" permissions in SQL Server 2012

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
permissionsconnect2012sqltwoserver

Problem

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

Solution

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.

Context

StackExchange Database Administrators Q#57096, answer score: 2

Revisions (0)

No revisions yet.