Information

Title	Cannot use SQLDUMP to dump systabauth and sysdbauth

URL Name	000036492

Article Number	000158984

Environment	Progress 9.1x OpenEdge 10.x, 11.x All Supported Operating Systems

Question/Problem Description

Cannot use SQLDUMP to dump systabauth and sysdbauth tables.
Cannot use SQLDUMP to dump sysprogres.systabauth and sysprogres.sysdbauth tables.
Cannot dump systabauth and sysdbauth tables.

Steps to Reproduce

Clarifying Information

Error Message	Database table(s) 'sysprogress.sysdbauth' not found. Database table(s) 'sysprogress.systabauth' not found.

Defect Number

Enhancement Number

Cause

sysprogres.sysdbauth is a schema table and SQLDUMP does not work with schema tables.
sysprogress.sysdbauth is a view and cannot be dumped.

Resolution

Use the sqlschema utility to dump SQL statements that capture the meaning of the schema table content (like privileges).
The created SQL statements can be transported and used in another db if desired.

Workaround

Notes

Progress Article(s):

"How to dump SQL-92 privileges"

Keyword Phrase

Last Modified Date	11/20/2020 7:35 AM