角色配置

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))

posted @ 2014-05-07 20:08  大漠孤烟~  阅读(209)  评论(0)    收藏  举报