Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In qlikview can we configure a section access and provide row level security using AD groups rather than user names?
i want the process to more maintainable. i.e. no need for changes in qlikview side
e.g. provide an AD group for a business segment and multiple users under that AD Group can see only that business segment
NTNAME | ACCESS | BusinessSegmentCode |
ORG\QlikVWSVC_Dev | ADMIN | * |
ORG\BusinessSegment1 | USER | 0001 |
ORG\BusinessSegment2 | USER | 0002 |
You can use groups and user names in the NTNAME field in a section access table. So if you'd rather use AD groups then use those instead of the user names.
from what i have read userid column seems to be mandatory for row level security.
hence the query row level security can be maintained through just ad groups.
if you know any examples of documents detailing this it would be great
thanks
D
Introduction to Section Access
Re: Section Access - Using a group name with spaces
Section Access and AD groups (NTNAME)
The USERID & PASSWORD combo does about the same as the NTNAME field with these differences:
If you use these techniques together, you will have double security (Windows account AND local UserID) but the end-user of your document will grow tired of having to log in over and over again. So do not do this unless you have good reasons to do so. And Row level security is not one of those, as you can implement row-level security just the same with just NTNAME and SSO.
BTW where did you read that story about row level security?
Peter