Resolution:
We provide SQL scripts you can run to grant privileges against system catalog tables. All are located in your
%ProgramFiles(x86)%\Micro Focus\Studio Enterprise Edition x.xmfsql\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.
