Grant Access to User Tables

You must authorize adapter users to access their tables and views with the GRANT SELECT statement. If you are unfamiliar with the GRANT command or if you do not have SELECT authorization for the tables (or views), contact your Db2 database administrator to assist you.

To distribute SELECT privileges, issue 

GRANT SELECT ON object_name TO {sqluserid|PUBLIC} ;

where:

object_name

Is the name of the table or view.

sqluserid

Allows all users to access the specified table or view.

 Information Builders