/* ================================================================================ 档案代号: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; |