角色配置

select * from smt_RolePermission

delete from smt_RolePermission
delete from smt_RolePermission where ModuleId NOT IN(105,110,111,112,113,73)

insert into smt_RolePermission
select 1,moduleid,‘‘ from smt_Module

select * from smt_User

select * from smt_Role

select * from smt_UserRole

select * from smt_UserPermission

select * from smt_Module

SELECT ASCII(CHAR(1))

角色配置,布布扣,bubuko.com

角色配置

原文：http://www.cnblogs.com/denghuachengle/p/3714522.html