关于Type的授权

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/23122232/viewspace-625864/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/23122232/viewspace-625864/