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
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24812612/viewspace-676636/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24812612/viewspace-676636/