/* ================================================================================ 档案代号:aay_file 档案名称:帐别使用者权限设定档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table aay_file ( aay01 varchar2(5) NOT NULL, /*帐别 */ aay02 varchar2(10) NOT NULL, /*使用者代码 */ aay03 varchar2(1) /*No Use */ ); create unique index aay_pk on aay_file (aay01,aay02); alter table aay_file add constraint aay_pk primary key (aay01,aay02) enable validate; grant select on aay_file to public; grant index on aay_file to public; grant update on aay_file to public; grant delete on aay_file to public; grant insert on aay_file to public; |