Wednesday, June 12, 2019

Import New user using SQL in Azure cloud DEV VM in D365 FO



INSERT INTO USERINFO(Id, Name, ENABLE, COMPANY,SID,NETWORKDOMAIN, NETWORKALIAS, ENABLEDONCE,LANGUAGE,
 HELPLANGUAGE, PREFERREDTIMEZONE, ACCOUNTTYPE,DEFAULTPARTITION)
VALUES ('<UserId>','<Name>',1,'<Default company login>','<SID>',
'https://sts.windows.net/',
'<Email Id>',1,'en-us','en-us',<Timezone>,2,1);

Insert into SECURITYUSERROLE (USER_, SECURITYROLE, ASSIGNMENTSTATUS, ASSIGNMENTMODE)
values ('<UserId>','199',1,1),
 ('<UserId>','217',1,1);

Step:

Method 1:
1. Right click on AOT -> Refresh
2. Full DB sync
3. iisreset

Method 2: (Method 1 is not working)
1. Right click on AOT -> Refresh
2. Build App Suite model with DB sync
3. iisreset

Method 3: (if Method 1 & 2 is not working)
1. Right click on AOT -> Refresh
2. Full Build All model with DB sync
3. iisreset




No comments:

Post a Comment

Copy Markup charges while posting purchase invoice using X++

 Copy Markup charges while posting purchase invoice using X++ Class: Important: Code logic is just for Reference.  New class => Duplicate...