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;

posted @ 2019-03-22 15:18  ChuckLu  阅读(10481)  评论(0编辑  收藏  举报