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

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.
tomaz108Asked:
Who is Participating?
 
PremanidhiConnect With a Mentor Commented:
connect  KL/password

grant select on AB_KDS to XLEE with grant option ;
0
 
pratikroyCommented:
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
 
tomaz108Author Commented:
// *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
 
tomaz108Author Commented:
KL.AB_KDS is table not view
0
 
seazodiacCommented:
you should grant  "select" with grant options:

like this:

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

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.