Hello All,
I have one view and I have fired GRANT SELECT privileges on one view but getting following error:
GRANT SELECT ON PRODUCTION_VW TO IMG_USER;
and error:
Error starting at line 18 in command:
GRANT SELECT ON PRODUCTION_VW TO IMG_USER;
Error report:
SQL Error: ORA-01720: GRANT-alternativet finns inte för 'ASW_SCHEMA.HOT_PROD'
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.
The view PRODUCTION_VW is built upon multiple tables and ASW_SCHEMA.HOT_PROD among those tables.
I have provided select grant to this table also but still I am getting same error whenever I am trying the grant query.
Please help me to provide the grant to the view.
Thanks