select distinct rp.RoleId, ri.Role,mo.Operation, rp.OPerationId,
case rp.Adds when 1 then 'Yes' else 'on' End as AllowAdd,
case rp.Views when 1 then 'Yes' else 'on' End as ViewAllow,
case rp.Deletes when 1 then 'Yes' else 'on' End as DeleteAllow,
case rp.Disapprove when 1 then 'Yes' else 'on' End as DisapproveAllow,
case rp.Approve when 1 then 'Yes' else 'on' End as ApprovedAllow
from RolePrivilege rp, RoleInfo ri, ModuleOperation mo
where rp.RoleID=ri.RoleID and rp.OPerationID=mo.OperationID and ri.RoleId=2;
No comments:
Post a Comment