Showing posts with label Disable users in AX using Sql Query. Show all posts
Showing posts with label Disable users in AX using Sql Query. Show all posts

Friday, July 26, 2019

Disable users in AX using Sql Query


Open SSMS> New Query> Copy paste and run the query


update USERINFO SET ENABLE=0
where NAME in ('Uma Shankar')


You can disable multiple users by passing comma separated user names in the where condition.


Thanks,
Uma
at No comments:
Labels:
Subscribe to: Posts (Atom)

Get Enum Id and Enum Value in D365FO using SQL and X++

 Below is the sql get enum id and enum value of a enum in D365 F&O using sql. SELECT   enumidtable . NAME           'Enum Name' ...