【013】获取用户权限ID

查询用户“admin”，所属组织机构编码“101”的所有角色权限ID

DECLARE @OrgID BIGINT,@UserID BIGINT
SELECT @OrgID=ID FROM dbo.Base_Organization WHERE Code='101'
SELECT @UserID=ID FROM dbo.Base_User WHERE Code='admin'

SELECT r.ID FROM dbo.Base_Role r
LEFT JOIN dbo.Base_UserOrgRole uor ON uor.[Role]=r.ID
LEFT JOIN dbo.Base_UserOrg uo ON uo.ID=uor.UserOrg
WHERE uo.[User]=@UserID AND uo.Org=@OrgID -- 一般赋值当前登录的UserID与OrgID