drop table t204_tb_phones
/
create table t204_tb_phones
    ( a_phone_n        char(8)             not NULL
    , f_loc_c          char(2)             NULL
    , f_div_c          char(2)             NULL
    , f_dpt_c          char(4)             NULL
    , a_badge_n        char(8)             NULL
    , a_uid_x          char(30)            NULL
    , a_uid_c          char(08)            NULL 
    )
/
grant select on t204_tb_phones    to commbill_user
/
exit;
