Problem:

We are unsure what userid/password to use when logging into SQLWizard. There is an error message

X091: User has no select privilege against sysibm.syslocations.

When would we use System/Install and when would we use Tutorial/Tutorial in the SQL Wizard definitions?

Resolution:

Using either the INSTALL authid or using a different authid and running sql to grant access (.sql files found in the mfe\\mfsql\\bin directory) will resolve the X091 error.

You would use any location (System or Tutorial or any other location) with the TUTORIAL authid when security is turned off. Check the MFE main menu>Options>SQL for DB2>Client, Security tab to see if security is enabled.

You would use any location with the INSTALL authid when security is turned on.

Tutorial is a regular user and does not have authority to locations when security is turned on - unless sql runs to grant authority.

INSTALL is a superuser:

- does not require a password

- can get to any location, except mainframe locations.

Also, please reference the Online Help: Contents tab>Using Mainframe Express>SQL Option for DB2>SQL Wizard>Security and Authority

Incident Number: 2436808