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

Convert Call stack to readable format in D365FO X++

//Input --container _xppCallStack = xSession::xppCallStack();  Public static str POL_formatXppCallStack(container _xppCallStack, int _skipFr...