Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
UserID2626
Partner - Creator III
Partner - Creator III

Section access is not working by connecting MYSQL Qlik Sense

Hi,

* is working fine when implementing section access by inline table.But I am trying to implement section by connecting with SQL, but i am not getting correct result for * while retrieving data from MYSQL for sectionaccess. 

Below is sql table values

Capture.PNG

Here admin and user009 should see all the data and user123 should see sales_123 part alone, but in my dashboard all users can see only sales_123. '*' is not working here for admin and user009.

 

Section Access;

LOAD

ACCESS,

USERID,

upper(SALES_ID) as SALES_ID;

SQL SELECT * FROM MYSQL_DATABASE.TABLE_NAME;

Section application;

Load

SALES_ID,

SALES_NAME,

AMOUNT

from sales_table;

Please help me to achieve * from MYSQL in section access

Labels (3)
1 Solution

Accepted Solutions
PeterVanOers
Contributor III
Contributor III

Hi,

I’ve been struggling with this also.

The * gives access to records is your table, in your case SALAES_123. To give the admin user access to all records, change the access from USER to ADMIN en  clear the * in the field SALES_ID.

This works for me.

And of course keep user id values uppercase. But it seems you have that.

I would also clear the * in the SA_SCHEDULAR record, so that the account van read all of the records.

Hope thishelps you out.

Peter.

View solution in original post

1 Reply
PeterVanOers
Contributor III
Contributor III

Hi,

I’ve been struggling with this also.

The * gives access to records is your table, in your case SALAES_123. To give the admin user access to all records, change the access from USER to ADMIN en  clear the * in the field SALES_ID.

This works for me.

And of course keep user id values uppercase. But it seems you have that.

I would also clear the * in the SA_SCHEDULAR record, so that the account van read all of the records.

Hope thishelps you out.

Peter.