Kbase P174238: OpenEdge Architect SQL connection shows schema details but no data when choosing the Preview option
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/10/2010 |
|
Status: Unverified
SYMPTOM(s):
OpenEdge Architect SQL connection shows schema details but no data when choosing the Preview option
[DataDirect][OpenEdge JDBC Driver][OpenEdge]Access Denied (Authorization Failed) (7512).
Error: <command name | SQL Exception message>. (8933)
FACT(s) (Environment):
No _user records exist in the database
Windows
OpenEdge 10.2B
CAUSE:
This is expected behavior. If there are no _user records, the SQL DBA permissions are only set for the name of the user who created the database.
CAUSE:
You must login with the username of the person who created the database or create a sysprogress user and connect with that.