SID Function (Database)

Type: Text

The SID of the specified Windows user account.

In the Classic client, if you add an alias to the Windows Logins form, then the SID for the alias is automatically added to the form. The SID is the primary key on the Windows Login table. In the RoleTailored client, if you create a page for adding Windows logins, then you must use the SID function to retrieve the SID for the user account so that you can enter the new login into the Windows Login table.

This function only runs on the computer running Microsoft Dynamics NAV Server. If you call this function from the Classic client, then no action occurs.

This example assigns the SID for Simon's Windows user account to a variable. This example requires that you create the following variables.

UserAccount := 'cronus\simon';
NewSID := SID(UserAccount);

Reference

Concepts