• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3910
  • Last Modified:

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.
0
tomaz108
Asked:
tomaz108
1 Solution
 
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
 
PremanidhiCommented:
connect  KL/password

grant select on AB_KDS to XLEE with grant option ;
0
 
seazodiacCommented:
you should grant  "select" with grant options:

like this:

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

0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now