Re: patch issue

Posted by Roshan on Dec 03, 2017; 5:55am
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/patch-issue-tp4594p4615.html

Hi,

I have checked

ORA-01031 occurs while Granting SELECT on DBA_USERS_WITH_DEFPWD to em_oam_monitor_role For Patch 20395533 (Doc ID 2093641.1)

Please find below output

SQL> conn / as sysdba
Connected.
SQL>  GRANT select on APPS.FND_FORM_SESSIONS_V to PUBLIC with grant opt

Grant succeeded.

SQL> commit;

Commit complete.

SQL> conn system/qz877wr3x2bqwu9j
Connected.
SQL>  GRANT select on APPS.FND_FORM_SESSIONS_V to em_oam_monitor_role;
 GRANT select on APPS.FND_FORM_SESSIONS_V to em_oam_monitor_role
                      *
ERROR at line 1:
ORA-01720: grant option does not exist for 'APPLSYS.FND_USER'



Regards,

Roshan