Jim Youmans
asked on
DB2 Admin rights granted to all local administrators?
DB2 10.5 on Windows Server 2012 R2.
Trying to figure out how security works with DB2 and Windows. My main concern is the Server Admin group. Here is what is confusing me.
By default, system administrative (SYSADM) authority is granted to any valid DB2® user account that belongs to the Administrators group on the computer where the account is defined. If the account is a local account, then it must belong to the local Administrators group. If the account is a domain account, then it must belong to the Administrators group at the domain controller or the local Administrators group. (https://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.7.0/com.ibm.db2.luw.qb.server.doc/doc/c0008762.html)
What does this mean? On my server when I look at the Local Users and Groups and look at the Administrators group, I see 4 or 5 domain groups that need to be admin on the server but I don't want them to by admins in DB2.
Is this saying that everyone in the Administrator group on the server is also an admin in DB2?
Thanks.
Jim
Trying to figure out how security works with DB2 and Windows. My main concern is the Server Admin group. Here is what is confusing me.
By default, system administrative (SYSADM) authority is granted to any valid DB2® user account that belongs to the Administrators group on the computer where the account is defined. If the account is a local account, then it must belong to the local Administrators group. If the account is a domain account, then it must belong to the Administrators group at the domain controller or the local Administrators group. (https://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.7.0/com.ibm.db2.luw.qb.server.doc/doc/c0008762.html)
What does this mean? On my server when I look at the Local Users and Groups and look at the Administrators group, I see 4 or 5 domain groups that need to be admin on the server but I don't want them to by admins in DB2.
Is this saying that everyone in the Administrator group on the server is also an admin in DB2?
Thanks.
Jim
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi,
Do you need any more assistance or clarification on this issue ?
Regards,
Tomas Helgi
Do you need any more assistance or clarification on this issue ?
Regards,
Tomas Helgi
That's an accurate assessment.
You should be able to revoke the privilege, though.
REVOKE SYSADM FROM user;
Kent