Home » RDBMS Server » Security » "ORA-01720: grant option does not exist for" using inherited user defined type (Oracle 10G)
"ORA-01720: grant option does not exist for" using inherited user defined type [message #644640] Wed, 11 November 2015 06:25 Go to next message
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

Re: "ORA-01720: grant option does not exist for" using inherited user defined type [message #644643 is a reply to message #644640] Wed, 11 November 2015 07:47 Go to previous message
Michel Cadot
Messages: 65202
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

If AA has not the EXECUTE privilege on bb.TYP_ORDER with GRANT OPTION then AA can't grant EXECUTE privilege on its TYP_CUST type.

Previous Topic: Tools for auditing database for finding plain text credit card numbers.
Next Topic: Verify sec_protocol_error_further_action
Goto Forum:
  


Current Time: Wed Nov 22 19:51:30 CST 2017

Total time taken to generate the page: 0.01686 seconds