ORA-01720: grant option does not exist for 'APPLSYS.FND_USER'

I have created a view as
DROP VIEW BOLINF.TPCO_SHIP_TO_LOCATION;

/* Formatted on 2/4/2013 10:31:56 AM (QP5 v5.149.1003.31008) */
CREATE OR REPLACE FORCE VIEW BOLINF.TPCO_SHIP_TO_LOCATION
(
   LOCATION_CODE,
   SHIP_TO_LOCATION_ID
)
AS
   SELECT UNIQUE HRL.LOCATION_CODE, PHA.SHIP_TO_LOCATION_ID
     FROM PO_HEADERS_ALL PHA,                              --PO_LINES_ALL PLA,
                             HR_LOCATIONS HRL, FND_USER FU
    WHERE     1 = 1
          --PHA.PO_HEADER_ID = PLA.PO_HEADER_ID
          AND HRL.LOCATION_ID = PHA.SHIP_TO_LOCATION_ID
          AND PHA.CREATED_BY = FU.USER_ID
--AND PHA.CANCEL_FLAG ='Y'
;


when i am trying to run this

grant SELECT on BOLINF.TPCO_SHIP_TO_LOCATION to apps

ORA-01720: grant option does not exist for 'APPLSYS.FND_USER'

i am getting this error
pardeshirahulAsked:
Who is Participating?
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
Think about it:
I grant you select on one of my tables.

You create a view on my table.

You grant select on your view to a friend of yours I don't know.

Should your friend be able to select against my table?
0
 
slightwv (䄆 Netminder) Commented:
You can only grant select permissions on a view if you have the admin option granted to you on the underlying objects.

If you Google the ORA-01720 error there is a lot of information out there on this.

Check out:
http://ora-01720.ora-code.com/
0
 
pardeshirahulAuthor Commented:
Now it is saying under lying objects of the view should also be granted to apps

for PO_HEADERS_ALL  the owner is PO and grant option is not given to apps
for HR_LOCATIONS the owner is apps
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.