/*
================================================================================
档案代号:gcj_file
档案名称:Express 报表权限设定
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table gcj_file
(
gcj01       varchar2(1),             /*分类                                   */
gcj02       varchar2(10) NOT NULL,   /*使用者代号/权限类别                    */
gcj03       varchar2(10) NOT NULL,   /*报表代码                               */
gcj04       varchar2(1),             /*执行程式否                             */
gcj05       varchar2(1),             /*no use                                 */
gcj06       varchar2(1)              /*no use                                 */
);

create unique index gcj_pk on gcj_file (gcj02,gcj03);
alter table gcj_file add  constraint gcj_pk primary key  (gcj02,gcj03) enable validate;
grant select on gcj_file to public;
grant index on gcj_file to public;
grant update on gcj_file to public;
grant delete on gcj_file to public;
grant insert on gcj_file to public;