Missing grants on HTP package after import? - ORA-00980: synonym translation is no longer valid
Oracle 9.2.0.8 on Solaris
Hi,
We get this error for a user after an import in 9i:
When trying to compile a package:
PLS 00201:identifier HTP.PRINT must be declared
PLS 00201:identifier HTP.HTMLOPEN must be declared
How can I grant this to myuser?
grant execute on HTP to myuser;
grant execute on HTP to myuser
*
ERROR at line 1:
ORA-00980: synonym translation is no longer valid
Any ideas?
Regards
TLD