Microsoft Dynamics NAV (Archived)

User security ID

(0) Share

Report

Posted on by Community Member

Hi All,

I want to get information from table User Group Members.

I defined a record variable (UserGroupMember) for this table and try the next function:

UserGroupMember.GET('VERKOPERS',SID(USERID),COMPANYNAME)

This give me an error:

Invalid form of GUID string

Any help is welcome,

Thanks,

Patrick

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (1)

Suggested answer

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (0)

Report

what is the table id of User Group Members?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

9001

Was this reply helpful? Yes No
Suggested answer

Saurav.Dhyani 14,380 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

The Result of SID(USERID) will get the Windows Security ID but

what the Table User Group Member is Looking a Different Security ID which was automatically Generated When you create a New User.

** The Field is Mapped To User Table (2000000120) Field - User Security ID.

I hope you understand my point. You are trying to assign Wrong Value in Get Statement.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Saurav,

Ok. But how do I get the information I need?

In need the User Security ID of the current user.

With that I can query table User Group Members.

Thanks,

Patrick

Was this reply helpful? Yes No
Suggested answer

Saurav.Dhyani 14,380 Super User 2025 Season 2 on at

Like (0)

Report

Hi Patrick,

Try This -

User1.Setrange("Windows Security ID",SID(USERID));

IF User1.FindFirst Then

UserGroupMember.GET('VERKOPERS',User1."User Security ID",COMPANYNAME)

Where User1 - is a variable of Table 2000000120.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Saurav,

It's not a windows user. So I think I cannot use this function?

User1.Setrange("Windows Security ID",SID(USERID));

Thanks,

Patrick

Was this reply helpful? Yes No
Suggested answer

Saurav.Dhyani 14,380 Super User 2025 Season 2 on at

Like (0)

Report

In That Case You Cannot use SID(UserID).

Then Try This -

User1.Setrange("user Name",YourUserName);

IF User1.FindFirst Then

UserGroupMember.GET('VERKOPERS',User1."User Security ID",COMPANYNAME)

Where User1 - is a variable of Table 2000000120.

and YourUserName - is the Username that you have given While Creating User.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Suarav,

I think this will solve the problem but I have one more question.

How do I get YourUserName: the name of the user currently logged in?

Thanks,

Patrick

Was this reply helpful? Yes No
Verified answer

Saurav.Dhyani 14,380 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

When You User USERID, Your get the User Name that is in the User table.

Read C/AL Help for USERID, it says so.

Was this reply helpful? Yes No
Suggested answer

4BzSoftware 6,073 on at

Like (0)

Report

Hi Patrick,

Is it what you need?

//gRec_User is record variable, table 2000000120 - User:

IF gRec_User.GET(USERSECURITYID) THEN

MESSAGE('%1 %2', gRec_User."User Name", gRec_User."Full Name");

Was this reply helpful? Yes No