ORA-01720: grant option does not exist for 'S.P'
- From: Dwaraknath Krishnamurthi <dwarak.k@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 10 Nov 2009 17:09:03 +0530
Greetings,
I have a schema S which holds a view V and a procedure P. I have also
defined a role R
Procedure P is used in the view definition V
when trying to execute
GRANT SELECT ON S.V to R
I encounter this error
ORA-01720: grant option does not exist for 'S.P'
P.S
I have already run this grant successfully
GRANT EXECUTE ON S.P TO R
Running 10.2.0.2
Any Help much appreciated.
Thanks,
Dwarak
Other related posts:
