权限管理之视图

CREATE VIEW dbo.Per_tree
AS
SELECT dbo.Base_User.User_no, dbo.Base_User.User_wkno,
dbo.Base_User.User_name, dbo.Menu_Tree.no, dbo.Menu_Tree.id,
dbo.Menu_Tree.node, dbo.Menu_Tree.root, dbo.Menu_Tree.text,
dbo.Menu_Tree.open_href, dbo.Menu_Tree.leaf, dbo.Menu_Tree.per,
dbo.Menu_Tree.other, dbo.Menu_Tree.orderby
FROM dbo.Base_User INNER JOIN
dbo.Per_user ON dbo.Base_User.User_per = dbo.Per_user.per_no INNER JOIN
dbo.Menu_Tree ON dbo.Per_user.tree_no = dbo.Menu_Tree.id