Stefano Bonicatti
12/13/2021, 2:20 PMgroups table. First of all on Windows the table, although hidden, will have a pid_with_namespace column, which has no meaning there. Not only that, since it's additional, it affects how the primary key is defined.
Then you have the groups_sid which is Windows specific and most likely the one that should be used to do filtering or joins (if it was implemented as index in the table), but you also have gid which is an information that do exist on Windows and can be matched to the gid returned from the users table.
Problem is that you can't filter in the APIs by gid and it's marked as index