求解

Question

表i_project_permit
----------------------------------------------------------------
| User | ProjectID | GroupCode    | RoleCode     | PermitCode  |
----------------------------------------------------------------
| U001 | P00000001 | G01;G02;G03; | R01;R02;R03; | P01;P02;P03;|
----------------------------------------------------------------
| U001 | P00000002 | G02;G04;     | R02;R04;     | P02;P04;    |
----------------------------------------------------------------
| U001 | P00000003 | G03;G04;     | R03;R04;     | P03;P04     |
----------------------------------------------------------------表i_role_permit
-----------------------------------------
| RoleCode | GroupCode    | PermitCode  |
-----------------------------------------
| R01      | G01;G04;     | P02;P05;    |
-----------------------------------------
| R02      | G02;G04;     | P02;P06;    |
-----------------------------------------
| R03      | G03;G05;     | P02;P07;    |
-----------------------------------------
| R04      | G04;G05;     | P02;P08;    |
-----------------------------------------表i_permit_group
-----------------------------------------
| GroupCode    | PermitCode             |
-----------------------------------------
| G01          | P01;P02                |
-----------------------------------------
| G02          | P03;P04                |
-----------------------------------------
| G03          | P05;P06                |
-----------------------------------------
| G04          | P07;P08                |
-----------------------------------------
| G05          | P09;P10                |
-----------------------------------------

Answer 1

解什么来着,查询?
根据用户ID,查询出他的权限?
拆解GroupCode | RoleCode 字段,然后去子表查就好了...

Answer 2

不好意思，刚才帖子不完整，现补充：根据UserId 查询出它的权限，例如：
UserId U001最终PermitCode = i_project_permit（PermitCode） + i_role_permit（PermitCode和） + i_permit_group（PermitCode和）