Permissions for creating or updating a schema holder
You must have select privileges on specific system tables or database catalog files in your ODBC data source to create or update a schema image for the data source. This is because the Data Dictionary must access the system tables in the data source to create or update the schema image, but it cannot do so without select privileges. However, this is the only time that you need this level of privilege when using the DataServer.
The following data-source permissions are required to create or update a schema holder:
DB2 UDB—You must have at least select permission on the following system objects: systables, syscolumns, sysindexes, and syskeys.
On DB2/MVS, you must grant BINDADD permission and CREATE IN COLLECTION NULLID permission to the host user.
Sybase—You must have at least select permission on the following system objects: syscolumns, sysindexes, sysobjects, and sysusers.
DB2 UDB—You must have at least select permission on the following system objects: systables, syscolumns, sysindexes, and syskeys.