View: dbo.Privilege_Dependency_View
View definition
create view dbo.Privilege_Dependency_View
as
select
privilege_dependency_KEY = PD.privilege_dependency_KEY
, privilege_KEY = PD.privilege_KEY
, privilege__description = P.description
, privilege__parent__privilege_KEY = P.parent__privilege_KEY
, dependent__privilege_KEY = PD.dependent__privilege_KEY
, dependent__privilege__description = P1.description
, dependent__privilege__parent__privilege_KEY = P1.parent__privilege_KEY
from
dbo.Privilege_Dependency PD
left outer join
dbo.Privilege P on P.privilege_KEY = PD.privilege_KEY
left outer join
dbo.Privilege P1 on P1.privilege_KEY = PD.dependent__privilege_KEY