How to assign users to groups in section access qliksense?

[krishna789]

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‌

swuehl‌stalwar1‌bill.markham‌stevedark‌rubenmarin‌adamdavi3s‌

[stevedark]

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

[krishna789]

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

[stevedark · Accepted solution]

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.

[krishna789]

Hi

For  group  table, structure in sql  follow this link :How to create user groups in Qlik Sense server.

Thanking you,

krishna