sql server查看用户权限

 System.ServiceModel.FaultException: Server error. Detail: The EXECUTE permission was denied on the object 'sp', database 'login', schema 'dbo'.

 

SELECT *
FROM sys.server_principals
WHERE name LIKE '%2019%';

SELECT *
FROM sys.server_permissions
WHERE grantee_principal_id = 396;

转载于:https://www.cnblogs.com/chucklu/p/10578448.html