Microsoft Dynamics Ax, Application Integration Framework, x++ programming, Ax 2009 , 2012. Enterprise portal, SharePoint , BI Tools, OLAP, OLTP, DAX, SQL database, 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 USERGROUPINFO

 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'

No comments:

Post a Comment

Active Search Results Technology Blogs