Kbase P21158: Oracle Dsrv: During schema pull, user is returned to Data Admin Menu with no errors after selecting
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/5/2010 |
|
Status: Verified
SYMPTOM(s):
Unable to perform a schema pull
Returns back to Data Administration after entering nothing within the second User ID and Password screen
The "Pre-Selection Criteria For Schema Pull" dialog-box does not appear
FACT(s) (Environment):
Using Add/update Table Definitions utility
User is valid in the ORACLE db
No errors in dataserv.lg
Using the same connection string and user name & password works against another Oracle instance
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
CAUSE:
Using a user to connect to ORACLE that has only resource priviledge granted.
For schema pull, the following permissions should also be granted
CREATE SESSION Database
select sys.argument$; sys.col$; sys.com$; sys.con$; sys.dual; sys.icol$; sys.ind$
sys.link$; sys.obj$; sys.procedure$; sys.seq$; sys.syn$; sys.tab$; sys.user$; sys.view$; sys.ts$
FIX:
Grant appropriate privileges from Oracle tools to the DataServer user.
Follow Solution 17082.
Once the schema holder is set up, the required ORACLE privileges vary among users depending on their applications.