OraFAQ Forum: Security » "ORA-01720: grant option does not exist for" using inherited user defined type

Home » RDBMS Server » Security » "ORA-01720: grant option does not exist for" using inherited user defined type (Oracle 10G)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

"ORA-01720: grant option does not exist for" using inherited user defined type [message #644640]

Wed, 11 November 2015 06:25

sshani
Messages: 1
Registered: November 2015

Junior Member

Hi,

I have a user defined type (e.g. aa.TYP_CUST), defined in a certain schema and I want it to use as one of its attributes a user defined type of another schema (e.g. bb.TYP_ORDER). This is how I defined my aa.TYP_CUST Type:
CREATE OR REPLACE
TYPE aa.TYP_CUST FORCE as object
(
CUST_NAME VARCHAR2(30)
, CUST_ADDRESS VARCHAR2(30)
, ORDERS bb.TYP_ORDER
);
/
I'm trying to grant a certain role EXECUTE privileges as follows:
GRANT EXECUTE ON aa.TYP_CUST TO my_role
I'm getting the following error:
"ORA-01720: grant option does not exist for 'bb.TYP_ORDER'"

I tried to add grant option to bb.TYP_ORDER but that didn't help.

Does anyone have any idea how to solve this issue?

Thanks,
Sharon

[Updated on: Wed, 11 November 2015 06:29]

Report message to a moderator