create sequence seq_name
   start with 1
   increment by 1
   maxvalue 999999
   nocycle
   cache 20;
create public synonym seq_name for owner.seq_name;
grant select on seq_name to joe_user;