/*
================================================================================
档案代号:zau_file
档案名称:自定义查询权限设定档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table zau_file
(
zau01       varchar2(80) NOT NULL,   /*查询单id                               */
zau02       varchar2(20),            /*资料所有者栏位                         */
zau03       varchar2(20),            /*资料群组栏位                           */
zau04       varchar2(1) NOT NULL     /*客制码                                 */
);

create unique index zau_pk on zau_file (zau01,zau04);
alter table zau_file add  constraint zau_pk primary key  (zau01,zau04) enable validate;
grant select on zau_file to public;
grant index on zau_file to public;
grant update on zau_file to public;
grant delete on zau_file to public;
grant insert on zau_file to public;