3 Replies Latest reply on Feb 13, 2020 12:56 PM by L. Fernigrini

    Grant command not invoked on view

    952939

      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