?
Solved

ORA-01720: grant option does not exist for 'KL.AB_KDS'

Posted on 2004-09-08
5
Medium Priority
?
3,907 Views
Last Modified: 2012-06-27
i have 3 schemas: CC, DD and KL. View XLEE is stored in schema DD. when i'm trying to
grant select on XLEE to CC; the following error is reported: ORA-01720: grant option does not exist for 'KL.AB_KDS'. what should i do? i already granted select on 'KL.AB_KDS' to CC.
0
Comment
Question by:tomaz108
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 9

Expert Comment

by:pratikroy
ID: 12005419
01720, 00000, "grant option does not exist for '%s.%s'"
// *Cause:  A grant was being performed on a view and the grant option was
//          not present for an underlying object.
// *Action: Obtain the grant option on all underlying objects of the view.


0
 

Author Comment

by:tomaz108
ID: 12005484
// *Action: Obtain the grant option on all underlying objects of the view.
 i already done that, but i still getting error: ORA-01720: grant option does not exist for 'KL.AB_KDS'
0
 

Author Comment

by:tomaz108
ID: 12005577
KL.AB_KDS is table not view
0
 

Accepted Solution

by:
Premanidhi earned 200 total points
ID: 12005671
connect  KL/password

grant select on AB_KDS to XLEE with grant option ;
0
 
LVL 23

Expert Comment

by:seazodiac
ID: 12005690
you should grant  "select" with grant options:

like this:

grant select on KL.AB_KDS to <user_name> with grant option;

0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many‚Ķ
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question