首页 > 代码库 > 角色配置

角色配置

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