WSQL042: Error in querying SYSACFUSERS.

The system encountered an error when attempting to retrieve information on users from the system catalog. This error occurs if you have not been granted privileges against the system catalog tables. You will be allowed to continue if you receive this error, but you will be connected as a regular user, not a super user.

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.