Solved

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

Posted on 2004-09-08
5
3,887 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
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 50 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Oracle -- identify blocking session 24 51
Clone Oracle 12c Database 5 52
PL SQL Search Across Columns 4 35
Field name with special character (Ñ) in Oracle 11 45
Article by: Swadhin
From the Oracle SQL Reference (http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm) we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to recover a database from a user managed backup

815 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now