groups and users

nittal · #1 (**permalink**) 08-12-08, 01:08

Hi All,
i am using db2 v8.1 ESE on windows.
m facing problem with providing access to users in db2
1. is any kind of log entry made while adding or removing users?
2. any user who is in admingroup automatically gets the admin rights without explicitly adding that user from control center?

przytula_guy · #2 (**permalink**) 08-12-08, 03:35

with admingroup, do you mean windows group administrators or any specific group you created and granted admin rights in db2

nittal · #3 (**permalink**) 08-12-08, 04:39

with admin group i mean, windows adminstrator group.

przytula_guy · #4 (**permalink**) 08-12-08, 08:09

no, only users/groups granted dba authority in db2 will have this authority

n_i · #5 (**permalink**) 08-12-08, 08:13

Quote:

Originally Posted by przytula_guy

no, only users/groups granted dba authority in db2 will have this authority

I think this is incorrect. I believe all members of the Administrators group on Windows have SYSADM autority.

nittal · #6 (**permalink**) 08-12-08, 09:12

hi,
i have verified that not all the users in the windows administrator group gets sysadmin authority. only db2admin has got all the privilges by default and other users can only connect to the database but cannot further access this databases.

przytula_guy · #7 (**permalink**) 08-12-08, 10:36

because db2admin is in the group that has been defined as sysadm group
db2 get dbm cfg and check

Internet Services

Web Development

Digital Marketing

Consumer Tech