create procedure YourUP
@UserID int
as
select @UserID,rp.PermissionId, rp.Permission
from UserToRole utr
inner join RolePermissions rp
on utr.RoleId=rp.RoleId
where utr.UserID=@UserID
@UserID int
as
select @UserID,rp.PermissionId, rp.Permission
from UserToRole utr
inner join RolePermissions rp
on utr.RoleId=rp.RoleId
where utr.UserID=@UserID
as
exec('select * from RolePermissions where RoleID in (select RoleID from UserToRole where UserID='''+@UserID+''')')
@UserID nvarchar(50)
as
select a.*
from RolePermissions a,UserToRole b
where b.UserID=@UserID and a.RoleId=b.RoleId
go
@UserID int
as
select *
from UserToRole a
join RolePermissions b
on a.RoleId=b.RoleId
where a.UserID=@UserID