using Nav4 SP2.
I wantt to use windows logins. I have a AD group with my users in this group. I have the group and the users in Nav in the windows login table. Both users and group SQL role is public.
If I assign "Super" to a users or to the group, everything works fine.
IF I assign other roles (and not super) it doesn't work.
I tried the assigned set of roles with a DB login and it works.
I did not forget to synchronize.
I did not have extende procedure "xp_ndo_enumusergroups" and before installing it even the super windows users did not work, but now yes.
I am using SQL 2000 SP3a.