Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to create user groups in Qlik Sense server

I'm adding users with the User Directory Connector and Sql Server.  I have 2 table created,  1 for userids, and 1 for their type/value pairs.

How do I go about adding users to groups?

thanks

2 Replies
Masaki_Hamano
Employee
Employee

Hi David,

Here is how UDC with SQL Server works:

1. Add user entries to "Users" table in SQL Server.

1.png

2. Add group entries to "Attributes" table. The column named "userid" is the key column connecting with a user entries in "Users" table.

2.png

3. Once the sync of UDC is executed, users with group information is added to Qlik Sense.

3.png

4. Now, you can use the group information in security rules.

4.png

Masaki

brijeshvma
Partner - Creator
Partner - Creator

Hi Masaki,

With ur given step 1 and 2 I created user and attribute table in mysql. But I am not able to load in UDC. Can you add step and connection string how to create