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
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

using SQL Query in X++

 If you need to execute sql query inside your X++ code then below example can help you. To pass value to SQL query we need to use strfmt() f...