Skip to main content
Question

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

  • November 8, 2023
  • 1 reply
  • 260 views

Forum|alt.badge.img+7
  • Do Gooder (Employee)
  • 17 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

durette
Superhero (Customer)
Forum|alt.badge.img+19
  • Superhero (Customer)
  • 526 replies
  • November 8, 2023
SASIUS wrote:

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings