asked on

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

slightwv (䄆 Netminder)

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/

pardeshirahul

ASKER

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

ASKER CERTIFIED SOLUTION

slightwv (䄆 Netminder)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial