inventory/intovqa2@wminvq2

qa_sc/qcvqa2@wminvq2

two schemas in the same DB wminvq2,

inventory has the following Objects

TABLE:

WIN_HOLIDAY

TYPE:

t_item_holiday_rec

t_item_holiday_tab

then the qa_sc user want to access the 3 Objects,

login the DB as inventory, do the follwing actions:

-- Create the synonym

create public synonym WIN_HOLIDAY

  for INVENTORY.WIN_HOLIDAY;

-- Create the synonym

create public synonym T_ITEM_HOLIDAY_REC

  for INVENTORY.T_ITEM_HOLIDAY_REC;

-- Create the synonym

create public synonym T_ITEM_HOLIDAY_TAB

  for INVENTORY.T_ITEM_HOLIDAY_TAB;

grant select, insert, update, delete on WIN_HOLIDAY to QA_SC;

grant EXECUTE, DEBUG on T_ITEM_HOLIDAY_REC to public;

grant EXECUTE, DEBUG on T_ITEM_HOLIDAY_TAB to public;

ORA-02305: only EXECUTE, DEBUG, and UNDER privileges are valid for types