Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts,
How to assign users to group in section access (Qliksense)
1.How to create a group in sql something like Table Structure.
2.How to assign a users group to Stream in Qmc .
Thanking you,
krishna
amo
swuehlstalwar1bill.markhamstevedarkrubenmarinadamdavi3s
If you google section access in Sense you will find lots of detail on how to set up section access, help.qlik.com is probably a good start.
Basically you need a list of names in a table, and a list of what they can see. This then needs to load into a system table within Section Access/Section Application tags, the fieldnames are important to get right.
The other gotcha is that if you give a user access to all (using a *) you need to ensure that every item they need access to is listed in the section access table. It's usually a good idea to have a dummy user who has access to all items explicitly, so that * works.
Hi Krishna,
You are referencing two very different things here, as there is not a link between Section Access and Streams.
The best way to group users in Section Access is to use an AD Group (if you are connecting to an AD) or to create a table which lists each user in each group which you can then load into Section Access.
To add users to a Stream you need to set up a security rule. When you come to do this you can either do the rule on a name matching, or the name of a group matching Again, if you are using AD, creating a security group for the stream against an AD Group is the best way of doing this - as it means that IT can put people in groups without having to know about Sense.
Steve
Hi stevedark ,
Thanks for your reply ,i dont have AD Group,can you please help me how to create a table which lists each user in each group which can be load into Qliksense QMC via sql odbc.can share table structure example tables ,column names ..etc
Thanking you
krishna
If you google section access in Sense you will find lots of detail on how to set up section access, help.qlik.com is probably a good start.
Basically you need a list of names in a table, and a list of what they can see. This then needs to load into a system table within Section Access/Section Application tags, the fieldnames are important to get right.
The other gotcha is that if you give a user access to all (using a *) you need to ensure that every item they need access to is listed in the section access table. It's usually a good idea to have a dummy user who has access to all items explicitly, so that * works.
Hi
For group table, structure in sql follow this link :How to create user groups in Qlik Sense server.
Thanking you,
krishna