Question

ORA-01720: grant option does not exist for 'SYS.ALL_DB_LINKS'

  • 8 November 2023
  • 1 reply
  • 121 views

Userlevel 3
Badge +7
  • Do Gooder (Employee)
  • 14 replies

Apps9 - UPD deploying failed on the customer non-prod environment.  Work without error on customer Apps9 internal environment.

Non-prod DB was refreshed using the PROD latest copy before UPD delivery deployment. 

 

SQL> exec ifsapp.Fndadm_Installation_API.Post_Installation_Data;

begin ifsapp.Fndadm_Installation_API.Post_Installation_Data; end;

ORA-01720: grant option does not exist for 'SYS.ALL_DB_LINKS'

ORA-06512: at "IFSAPP.SECURITY_SYS", line 2355

ORA-06512: at "IFSAPP.SECURITY_SYS", line 1223

ORA-06512: at "IFSAPP.PRES_OBJECT_UTIL_API", line 2766

ORA-06512: at "IFSAPP.PRES_OBJECT_UTIL_API", line 2766

ORA-06512: at "IFSAPP.PRES_OBJECT_UTIL_API", line 2852

ORA-06512: at "IFSAPP.PRES_OBJECT_UTIL_API", line 262

ORA-06512: at "IFSAPP.PRES_OBJECT_UTIL_API", line 267

ORA-06512: at "IFSAPP.SECURITY_SYS", line 1265

ORA-06512: at "IFSAPP.FNDADM_INSTALLATION_API", line 359

ORA-06512: at "IFSAPP.FNDADM_INSTALLATION_API", line 476

ORA-06512: at "IFSAPP.FNDADM_INSTALLATION_API", line 33

ORA-06512: at "IFSAPP.FNDADM_INSTALLATION_API", line 37

ORA-06512: at line 1


1 reply

Userlevel 7
Badge +18

Apps9 - UPD deploying failed on the customer non-prod environment.  Work without error on customer Apps9 internal environment.

If you use DataPump as the SYSTEM user, it won’t include grants on SYS objects and won’t include system privileges. I recommend doing nonproduction copies with RMAN instead.

Reply