Kbase P5700: Getting SQL Permissions Error Accessing A Table In Report Bu
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
09/01/2004 |
|
Status: Unverified
SYMPTOM(s):
Getting SQL permissions error accessing a table
** Insufficient access privilege for table <name>. (978)
Report Builder
CHANGE:
Disallowed blank user ID's in Progress db.
CAUSE:
When you save a report it embeds the user ID into the report. All of these reports were created with blank ID's.
FIX:
1. Change Options -> Preferences -> Database Connection on Report Open to Prompt always.
2. Open each report with the correct username and password.
3. Save each report thus changing the userid from blank to the corrected user information.