Viewing 4 posts - 1 through 4 (of 4 total)
No roles and no permissions directly assigned to the server principal
July 4, 2018 at 4:06 am
To elaborate, I would like to understand how I have acquired permission to use the dbo database principal.
July 4, 2018 at 3:30 am
1 sa SQL_LOGIN GRANT CONNECT SQL
2 public SERVER_ROLE GRANT VIEW ANY DATABASE
101 ##MS_SQLResourceSigningCertificate## CERTIFICATE_MAPPED_LOGIN GRANT VIEW ANY DEFINITION
102 ##MS_SQLReplicationSigningCertificate## CERTIFICATE_MAPPED_LOGIN GRANT AUTHENTICATE SERVER
102 ##MS_SQLReplicationSigningCertificate## CERTIFICATE_MAPPED_LOGIN GRANT VIEW ANY DEFINITION
102 ##MS_SQLReplicationSigningCertificate## CERTIFICATE_MAPPED_LOGIN GRANT VIEW SERVER STATE
103 ##MS_SQLAuthenticatorCertificate## CERTIFICATE_MAPPED_LOGIN GRANT AUTHENTICATE SERVER
105 ##MS_PolicySigningCertificate## CERTIFICATE_MAPPED_LOGIN GRANT CONTROL SERVER
105 ##MS_PolicySigningCertificate## CERTIFICATE_MAPPED_LOGIN GRANT VIEW ANY DEFINITION
106 ##MS_SmoExtendedSigningCertificate## CERTIFICATE_MAPPED_LOGIN GRANT VIEW ANY DEFINITION
257 ##MS_PolicyTsqlExecutionLogin## SQL_LOGIN GRANT CONNECT SQL
257 ##MS_PolicyTsqlExecutionLogin## SQL_LOGIN GRANT VIEW ANY...
July 4, 2018 at 3:25 am
Viewing 4 posts - 1 through 4 (of 4 total)