This error occurs if you attempt to start SQLWizard when you have not been granted privileges for the system catalog tables.
Restriction: This topic applies to Windows environments only.
Resolution:
We provide SQL scripts you can run to grant privileges against system catalog tables. All are located in your
%ProgramData%\Micro Focus\Enterprise Developermfsql\cfg directory and must be run from there.
Note:
Scripts with filenames beginning with
XP enable you to grant privileges to the PUBLIC user ID. Scripts with filenames beginning with
XU enable you to grant privileges to any user ID other than PUBLIC.
- XPALLVU.SQL and
XUALLVU.SQL - Create a view of the system catalog tables of a location and grant select privileges on that view.
- XPGRTALL.SQL and
XUGRTALL.SQL - Grant select privileges on the system catalog tables of a location.
- XPGRTSYS.SQL and
XUGRTSYS.SQL - Grant select privileges on the system catalog tables of the SYSTEM location.
- XPSYSVU.SQL and XUSYSVU.SQL - Create a view of the system catalog tables of the SYSTEM location and grant select privileges on that view.
