topic Section Access osuser() vs os group in QlikView

Section Access osuser() vs os group

sangland2 — Wed, 25 Nov 2020 16:16:04 GMT

Hi, I have been using Section Access with the strict exclusion and NTNAME option for some time now. Star access was granted to DOMAIN\Administrators. A new user was set up DOMAIN\user.name with a reduction for 3 out of 56 companies in the model data. This works for all other users except the new user. We could verify the section access data matched OSUSER(). We eventually found that the user was incorrectly a member of DOMAIN\Administrators with full access. Without DOMAIN\Admin privileged, it was pretty hard to discover this. The user was removed from AD ADministrators and immediately the reduction worked. Is it possible to report on what OSGROUPS() the user belongs to?

Re: Section Access osuser() vs os group

jyothish8807 — Mon, 10 Dec 2018 05:56:35 GMT

Hi Sangland,

I believe you have to find it from the server it self.

May be this is what you want:

https://serverfault.com/questions/111650/how-can-i-find-out-what-ad-groups-im-a-member-of

Re: Section Access osuser() vs os group

jyothish8807 — Mon, 10 Dec 2018 06:00:21 GMT

Try this in power shell

(Get-ADUser userName –Properties MemberOf).MemberOf