<div>
Hi Jim,<br />
<br />
That's an accurate assessment. &nbsp;<br />
<br />
You should be able to revoke the privilege, though.<br />
<br />
&nbsp; REVOKE SYSADM FROM user;<br />
<br />
<br />
Kent
</div>


Sr Database Administrator

Jim Youmans

<div>
Hi, <br />
<br />
Do you need any more assistance or clarification on this issue ? <br />
<br />
Regards,<br />
&nbsp; &nbsp; &nbsp;Tomas Helgi
</div>


<div>
<div class="content wysiwyg-content">
DB2 10.5 on Windows Server 2012 R2.<br />
<br />
Trying to figure out how security works with DB2 and Windows. &nbsp;My main concern is the Server Admin group. &nbsp;Here is what is confusing me.<br />
<br />
<i>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. (<a href="https://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.7.0/com.ibm.db2.luw.qb.server.doc/doc/c0008762.html" rel="ugc">https://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.7.0/com.ibm.db2.luw.qb.server.doc/doc/c0008762.html</a>)</i><br />
<br />
What does this mean? &nbsp;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.<br />
<br />
Is this saying that everyone in the Administrator group on the server is also an admin in DB2?<br />
<br />
Thanks.<br />
<br />
Jim
</div>
</div>


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

DB2 Admin rights granted to all local administrators?

This topic area includes legacy versions of Windows prior to Windows 2000: Windows 3/3.1, Windows 95 and Windows 98, plus any other Windows-related versions including Windows Mobile.

Windows OS

Windows Server 2012 is the server version of Windows 8 and the successor to Windows Server 2008 R2. Windows Server 2012 is the first version of Windows Server to have no support for Itanium-based computers since Windows NT 4.0. Windows Server 2012, now in its second release (Windows Server 2012 Release 2) includes Foundation, Essentials, Standard and Datacenter, and does not support IA-32 or IA-64 processors.

Windows Server 2012

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.