Salesforce

Cannot use SQLDUMP to dump systabauth and sysdbauth

« Go Back

Information

 
TitleCannot use SQLDUMP to dump systabauth and sysdbauth
URL Name000036492
Article Number000158984
EnvironmentProgress 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 MessageDatabase 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
Keyword Phrase
Last Modified Date11/20/2020 7:35 AM

Powered by