web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Creating User

(0) ShareShare
ReportReport
Posted on by

Hello Guys,

I have to create 68 users in a day, what is the easiest way to create users. 

Thanks,

Sufyain

*This post is locked for comments

  • mmv Profile Picture
    11,471 on at

    Hi,

    You may use the powershell script:-

    https://nav-magno.be/2015/08/creating-users-with-powershell/

  • Suggested answer
    Amol Salvi Profile Picture
    18,698 on at

    You can use RapidStart tool for user creation

  • Community Member Profile Picture
    on at

    You can also use a query in SQL Management Studio to add new users. This query works for NAV 2016 database schema (I haven't tested it in NAV 2015, but it probably will work). Note that this query must be executed one time per user, this query works only for Windows users, and you would need to change some of the parameters to fit your particular situation. I highlighted the parameters in bold. The first parameter is the database name. The other parameters in bold may be self-explanatory.

    USE [NAVDEMO]

     

    DECLARE @USERSID uniqueidentifier, @WINDOWSSID nvarchar(119), @USERNAME nvarchar(50), @USERSIDTXT varchar(50), @EMAIL varchar(50)

     

    SELECT NEWID()

    SET @USERNAME   = 'WIN-V5E6TMK7C4L\Administrator'

    SET @USERSID   = NEWID()

    SET @USERSIDTXT = CONVERT(VARCHAR(50), @USERSID)

    SET @WINDOWSSID = 'S-1-5-21-3993832035-3231277643-1611983836-500'

    SET @EMAIL = 'email@email.com'

     

    INSERT INTO [dbo].[User]

             ([User Security ID],[User Name],[Full Name],[State],[Expiry Date],[Windows Security ID],[Change Password],[License Type],[Authentication Email],[Contact Email])

       VALUES

             (@USERSID,@USERNAME,'',0,'1753-01-01 00:00:00.000',@WINDOWSSID,0,0,@EMAIL,@EMAIL)

     

    INSERT INTO [dbo].[User Property]

             ([User Security ID],[Password],[Name Identifier],[Authentication Key],[WebServices Key],[WebServices Key Expiry Date],

             [Authentication Object ID])

       VALUES

             (@USERSID,'','','','','1753-01-01 00:00:00.000','')

     

    INSERT INTO [dbo].[Access Control]

             ([User Security ID],[Role ID],[Company Name],[Scope],[App ID])

       VALUES

             (@USERSID,'SUPER','','0','00000000-0000-0000-0000-000000000000')

    INSERT INTO [dbo].[User Personalization]

             ([User SID],[Profile ID],[Language ID],[Company],[Time Zone],[Debugger Break On Error],[Debugger Break On Rec Changes],[Debugger Skip System Triggers],[Locale ID])

       VALUES

             (@USERSID,'SALES ORDER PROCESSOR','1107,'Cronus Australia Pty. Ltd.','FLE Standard Time','1','0','1','1033')

    GO

  • Suggested answer
    Tharanga Chandrasekara Profile Picture
    23,118 on at

    You can use powershell for creating users.

    Link : msdn.microsoft.com/.../jj672917(v=nav.90).aspx

    Link 02 : nav-magno.be/.../creating-users-with-powershell

    If you play around you can write an function to repeat the user creation, which will ease your life.

  • Suggested answer
    Alexander Ermakov Profile Picture
    28,096 on at

    My best vote is to use PowerShell for creating new users:

    www.youtube.com/watch

    community.dynamics.com/.../creating-users-with-powershell

  • Suggested answer
    4BzSoftware Profile Picture
    6,073 on at

    Hi Sufyain,

    My suggestion is Powershell as Mahesh, Tharanga and Alexander mentioned.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans