权限管理_CPS_FUNC_PERMISSION_DATA

if exists(select 1 from sys.sysforeignkey where role='FK_CPS_FUNC_FK_CPS_FU_CPS_PERM') then
    alter table CPSSYS.CPS_FUNC_PERMISSION_DATA
       delete foreign key FK_CPS_FUNC_FK_CPS_FU_CPS_PERM
end if;

if exists(select 1 from sys.sysforeignkey where role='FK_CPS_FUNC_FK_CPS_FU_CPS_DATA') then
    alter table CPSSYS.CPS_FUNC_PERMISSION_DATA
       delete foreign key FK_CPS_FUNC_FK_CPS_FU_CPS_DATA
end if;

if exists(
   select 1 from sys.systable
   where table_name='CPS_FUNC_PERMISSION_DATA'
     and table_type in ('BASE', 'GBL TEMP')
     and creator=user_id('CPSSYS')
) then
    drop table CPSSYS.CPS_FUNC_PERMISSION_DATA
end if;

/*==============================================================*/
/* Table: CPS_FUNC_PERMISSION_DATA                              */
/*==============================================================*/
create table CPSSYS.CPS_FUNC_PERMISSION_DATA
(
   PERMISSION_IDENTIFIES VARCHAR2(100)                  not null,
   DATAPERMISSION_ID    VARCHAR2(100)                  not null,
   PARENT_DATAPERMISSION_ID VARCHAR2(100)                  null,
   ALLOWALLITEM         VARCHAR2(1)                    null,
   IDENTITY_TYPE        VARCHAR2(4)                    not null,
   constraint PK_CPS_FUNC_PERMISSION_DATA primary key (PERMISSION_IDENTIFIES, DATAPERMISSION_ID, IDENTITY_TYPE)
);

comment on table CPSSYS.CPS_FUNC_PERMISSION_DATA is
'<EnglishName>
CPS_FUNC_PERMISSION_DATA
</EnglishName>

<EnglishComment>
This table is used to define what operation permission
needs to be checked by data granularity.
</EnglishComment>

<ChineseComment>
定义系统里哪些功能权限下需要进行数据权限的管理
</ChineseComment>';

comment on column CPSSYS.CPS_FUNC_PERMISSION_DATA.PERMISSION_IDENTIFIES is
'<EnglishName>
Permission Identity
</EnglishName>

<EnglishComment>
The unique identifier of an operation permission.

</EnglishComment>

<ChineseComment>
功能权限唯一标识符
</ChineseComment>';

comment on column CPSSYS.CPS_FUNC_PERMISSION_DATA.DATAPERMISSION_ID is
'<EnglishName>
Data Permission ID
</EnglishName>

<EnglishComment>
The unique identifier of a data granularity. Its value must be defined in the table CPS_DATA_PERMISSION_DEF.

</EnglishComment>