Kbase P114238: Privilege error when pulling oracle schema into schema holder due to incorrect permission on sys.lin
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
30/05/2008 |
|
Status: Verified
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
SYMPTOM(s):
Error when pulling oracle schema into schema holder.
Please also verify you have SELECT privileges on the needed system tables and the proper version of ORACLE (7 or 8) was selected when the schema holder was created (328) (6483)
Error received prior to seeing the list of objects from Oracle
The error also appears when logging as SYSTEM
When executing SELECT * FROM sys.link$ from SQL*Plus, one of the following errors occurs:
ORA-00942: table or view does not exist
ORA-01031: insufficient privileges
CAUSE:
The user specified when pulling the ORACLE tables does not have SELECT privilege on sys.link$.
FIX:
Grant SELECT privilege to the user.
From SQL*Plus, follow the steps below in order to grant SELECT permission on sys.link$:
1- Connect to the ORACLE instance as SYSDBA:
connect <user> as sysdba;
2- Specify the user's password
3- Grant SELECT privilege:
grant select on sys.link$ to <user>;