sqlsql-serversql-server-2012navisiondynamics-nav-2015

How to create NAV user by SQL Query in NAV 2015


I need create a user for NAV 2015 from SQL Server 2012 by query.

Anyone know how to do this?

Thanks in advance.


Solution

  • Here the answer

    Get your windows SID by CMD console execute

    whoami/user
    

    SQL Query:

    USE [YourDatabase]
    DECLARE @USERSID uniqueidentifier, @WINDOWSSID nvarchar(119), @USERNAME     
    nvarchar(50)
    SET @USERNAME   = 'Domain\user'
    SET @USERSID    = newid()
    SET @WINDOWSSID = 'Your SID'
    
    INSERT INTO [dbo].[User]
          ([User Security ID],[User Name],[Full Name],[State],[Expiry Date],
           [Windows Security ID],[Change Password],[License Type],
    
    [Authentication Email])
    VALUES
          (@USERSID,@USERNAME,'',0,'1753-01-01 00:00:00.000',@WINDOWSSID,0,0,'')
    
    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])
    VALUES
          (@USERSID,'SUPER','')
    
    GO