Authorizations and privileges

When you open a project, you must enter the user ID and password to connect to the database server where the project is located.

Data Express can save login information and use it for future connections to the same project, so you do not need to enter your user ID and password every time you connect. However, not saving login information is the default behavior.

The user ID used to establish the database connection must have read privileges on the following tables or views:

  • All tables created by Data Express in the MVS, OS/390, or z/OS DB2 environment during the installation phase.
  • SYSIBM.SYSTABLES
  • SYSIBM.SYSCOLUMNS