/*
================================================================================
档案代号:smu_file
档案名称:单别限定使用者明细档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table smu_file
(
smu01       varchar2(6),             /*单    别                               */
smu02       varchar2(10),            /*设限使用者编号                         */
                                     /*设限使用者编号(Login user)             */
smu03       varchar2(3),             /*系统别                                 */
smu04       varchar2(1)              /*No Use                                 */
);

create        index smu_01 on smu_file (smu01,smu02,smu03);
grant select on smu_file to public;
grant index on smu_file to public;
grant update on smu_file to public;
grant delete on smu_file to public;
grant insert on smu_file to public;