IBM DB2 LUW: Setting up Source User Privileges

To be able to connect to a database and to extract DDL of objects in DB2, you need to create a user in the operational system where the DB2 server is installed. In this case you will be able to connect to the DB2 database using the credentials of this user and extract definitions of business logic objects in this database. To be able to extract the definitions of the tables and data stored in these tables you need to grant SELECT permission on a specific table which should be extracted:

• grant select on db2totd.address to user1.

Or you can grant access to all the data (ie, all tables in all schemas), then you need to grant dataaccess privilege to the user:

• db2 grant dataaccess on database to user user1.

If you have any other questions, please contact us: support@ispirer.com