Re: Lost ability to retrieve the schemes from MSSQL once we replaced our MSSQL 2008 R2 version with 2017 version

[Jacob Nikom]

Hello Milosz,

I tried to execute this query:
GRANT VIEW ANY DATABASE TO OSDprod;

However, it produced an error:
Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.

I think I don't have enough privileges for this operation.
Is it expected?

I ran this query and got the following results:
SELECT l.name as grantee_name, p.state_desc, p.permission_name
FROM sys.server_permissions AS p JOIN sys.server_principals AS l
ON p.grantee_principal_id = l.principal_id
WHERE permission_name = 'VIEW ANY DATABASE' ;
GO
-------------------------------------------
grantee_name state_desc permission_name
-------------------------------------------
public GRANT VIEW ANY DATABASE
-------------------------------------------