Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01720 while trying to grant select on a view

540831Feb 1 2007 — edited Feb 2 2007
Hi Friends,

Iam getting the following error while trying to grant select privilege for the view to SchemaB, i have the view in schemaA.

I have used the tables from both the schema for creating the view and iam getting the error on showing a particular table

ORA-01720: grant option does not exist for 'schemaB.Product'.

I have looked into so many forums but i couldn't find the answer for my question.

I must have to create the view in the Schema A only(strictly), as i seen in some forums stated that while creating the view in the other schema and granting the select privilege will solve the problem.But it was an exception to me ...


Tell me something how can i proceed in this .....
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 2 2007
Added on Feb 1 2007
6 comments
3,094 views