Kbase P53190: Create DataServer Schema not possible
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
SYMPTOM(s):
Create DataServer Schema not possible
No display of the screen "Pre-Selection Criteria For Schema Pull", after validation of "User ID and Password"
Last entry from dataserv.lg (using "-Dsrv qt_debug,EXTENDED" as additional connection parameters) shows
SELECT /*+ ROWID(T0) */ USER#,NAME FROM sys.user$ T0
CAUSE:
User has no permission to run, from SQL*Plus, the command
SELECT /*+ ROWID(T0) */ USER#,NAME FROM sys.user$ T0
FIX:
Give permissions needed to the user who has to run
Create DataServer Schema
The user needs CREATE SESSION permission as well as SELECT permission on the following System objects:
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$