Kbase P48288: Error 6483 after Oracle is upgraded to 9.2, granting more permissions to fix
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/12/2005 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1D
Oracle 9i
Oracle DataServer
SYMPTOM(s):
Getting error 6483 when performing Update/add table definitions
Getting error 6483 from schema pull
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
Oracle database upgraded from 8i to 9.2
The user is granted roles as following: dba, resource, read_tables and connect
CAUSE:
In Oracle 9, the 07_DICTIONARY_ACCESSIBILITY initialization parameter was changed to default to false instead of true.
FIX:
Grant "select any dictionary" priviledge. SQL syntax would be:
grant select any dictionary to my_user;