grants

-- useful for the new users

grant select on pending_trans$ to v_pak;

grant select on dba_2pc_pending to v_pak;

grant select on dba_pending_transactions to v_pak;

grant execute on dbms_system to v_pak;

grant select any dictionary to v_pak;

-- for connect GRANT CREATE SESSION TO sq_user; -- for create table and sequence,etc. GRANT RESOURCE TO sq_user; -- for 2PC grant select on pending_trans$ to sq_user; grant select on dba_2pc_pending to sq_user; grant select on dba_pending_transactions to sq_user; grant execute on dbms_system to sq_user;