se*****@hotmail.com (sea) wrote in message news:<f8**************************@posting.google. com>...
In order to have System Administrator privileges for the DB2 database,
is it necessary to have Administrative access (log on as
administrator) on the computer where DB2 is installed? Or, if a person
logs on as power user will they be able to do administrative tasks on
the database? Thank you very much!
We've been fighting this battle ourselves (on DB2 Personal Edition).
Our Network Administrators don't like the idea of db2admin having
administrator authority on the developers desktops. We still install
the db2admin user and use it to start up the DB2 services. Then just
the Network Administrators get to know the password for db2admin.
Then we create a local group (i.e. ADMGRP) on the computer and add the
developers network ID to the group. Then we configure any db2
instances and the admin instance to use SYSADM_GROUP=ADMGRP. Then the
developer has the admin rights needed in DB2 and do not have to have
admin rights on the computer.
HTH,
klh