Tuesday, July 11, 2006

DB2 Grant User Permissions

This is just an example.

We need to have an user called apsuite to access all instances, e.g. db2inst1 and db2inst3. All DB2 installations are 8.2.

$db2 connect to aps6331
$db2 grant bindadd, connect, createtab on database to user apsuite
$db2 connect reset

Do these three steps for all participated databases on all instances.

Done!

No comments: