Microsoft Dynamics Ax, Application Integration Framework, X++ programming, AX 2009 , 2012.Ax Rainier or version 7, Enterprise portal, SharePoint , BI Tools, OLAP, Performance Tuning, SSRS,SSIS,SSAS, Workflow.

Friday, June 21, 2013

How to Change user group of user from sql query editor

If you are not able to change user group of particular user and any problem occurred then you can modify user group of user from SQL back end through update query using query editor.


 Select * from USERGROUPLIST

To modify user group you can use following update statement to add user testuser to admin group  of Axapta.

Update USERGROUPLIST set GROUPID='Admin' where USERID='testuser'