drop table t204_tb_ccmstr
/
create table t204_tb_ccmstr
    ( a_ccard_n         char(10)        NOT NULL
    , a_badge_n         char(8)             NULL
    , a_uid_x           char(30)            NULL
    , f_loc_c           char(2)             NULL
    , f_div_c           char(2)             NULL
    , f_dpt_c           char(4)             NULL
    , a_uid_c           char(8)             NULL
    )

/
grant select on t204_tb_ccmstr    to commbill_user
/
exit;
