We are on AX2012 R3 CU8. The query is based on the AOTNAME field = '-SYSADMIN-', possibly yours is different.
The query should give you the same results as going to System Administration -> Setup -> Security -> Security Role and selecting System Administrator. Then look in the "Users with selected role" area.
Original Message:
Sent: 09-23-2016 11:32
From: Prasad GVSRK
Subject: Built-In Sys Admin roles?
Hi Mike,
Thanks for sharing the SQL . I ran the query in our environment and the results did not match with what I see through client. what could be the reason?
------------------------------
Prasad GVSRK
Capital Metropolitan Transportation Authority
Austin TX
Original Message:
Sent: 09-23-2016 08:20
From: Mike Fechter
Subject: Built-In Sys Admin roles?
The Admin is a built-in roll. The BCProxyU account is most likely running your AOS Service.
I suspect the wfexc is from a third party app that you're running, possibly used on some server. The Dynamics1 may be left over from a previous upgrade.
Check the login history for to see if the accounts are being used to access AX via the client. I would disable the Dynamics1 & wfexc and see what happens.
I use the following T-SQL query to monitor who is a Sys Admin and if they are enabled or not.
SELECT
UI.ENABLE as Enabled, ' ' as ' ', UI.name as 'System Admin'
FROM
IIMAK_AX2012_R2_Prod.dbo.SECURITYUSERROLe SUR
join IIMAK_AX2012_R2_Prod_model.dbo.SECURITYROLE SR on SUR.SECURITYROLE = SR.RECID
join IIMAK_AX2012_R2_Prod.dbo.userinfo UI on SUR.USER_ = UI.id
WHERE
AOTNAMe = '-SYSADMIN-' order by ui.name
Regards,
Mike
------------------------------
Mike Fechter
Lead Business Systems Analyst
IIMAK
Amherst NY
Original Message:
Sent: 09-22-2016 16:01
From: Margaret Trissel
Subject: Built-In Sys Admin roles?
New to AX 2012 and trying to lock down security. I noted that there are 4 generic users with the Sys Admin role: Admin, BCProxyU, Dynamic1 and wfexc. Are these built-in users to support future enhancements/hot fixes, etc?
I don't want to remove anything, but need to confirm security.
------------------------------
Margaret Trissel
Rogers Memorial Hospital
Oconomowoc WI
------------------------------