SELECT OBJECT_NAME(major_id),USER_NAME(grantee_principal_id),permission_name FROM sys.database_permissions p WHERE OBJECT_NAME(major_id) = 'MyProc'
您可以调整此参数以连接到sys.database_principals或sys.objects(如果您也希望)
