2015年计算机四级指导：用户，角色，功能之间的关系视图
发布时间：2010/3/10 18:03:57 来源：城市学习网 编辑：MOON
用户，角色，功能之间的关系视图： 假设你目前有下面的数据库结构：create table userinfo，name varchar);create table rolei ...
用户，角色，功能之间的关系视图：
假设你目前有下面的数据库结构：
create table userinfo，name varchar);create table roleinfo，name varchar);create table functioninfo，name varchar);create table userrole，roleid varchar);create table rolefunction，functionid varchar);insert into userinfo values;insert into userinfo values;insert into userinfo values;insert into roleinfo values;insert into roleinfo values;insert into roleinfo values;insert into functioninfo values;insert into functioninfo values;insert into functioninfo values;insert into userrole values;insert into userrole values;insert into userrole values;insert into userrole values;insert into userrole values;insert into userrole values;insert into role function values;insert into role function values;insert into role function values;insert into role function values;insert into role function values;insert into role function values;你可以根据三者连接的结果建立视图，得出整个权限模型的数据。
select u.name as username，r.name as rolename，f.name as functionnamefrom userrole ur inner join userinfo u on ur.userid=u.idinner join roleinfo r on ur.roleid=r.idinner join rolefunction rf on rf.roleid=r.idinner join functioninfo f on rf.functionid=f.idorder by u.name;结果如下：
