topic Section Access with SQL in QlikView

Section Access with SQL

Mon, 01 Mar 2010 17:15:08 GMT

I have created a section access like this :

Security:

load UPPER(UserCode) as USERID,

"USER" as ACCESS;

select * from G_USAGER;

load "ADMIN" as USERID

"ADMIN" as ACCESS;

section access;

load USERID, ACCESS

resident Security;

section application;

xxxx

xxx

I am only able to log in the application using the ADMIN User .

the others are rejected.

Any idea ?

Thanks a lot

Philippe

Section Access with SQL

johnan — Tue, 02 Mar 2010 10:03:17 GMT

Hi,

The section access must be in the top.

In my applications i have a INLINE with Admin rights:

Paste Your User rights here then

//AdminTable

JOIN LOAD * inline [

SERIAL,USERID,PASSWORD,ACCESS

SERIALNUMBER,,,ADMIN

*,USER,PASS,ADMIN];

The Serialnumber is good because i never have to sign in with User, Pass

Section Access with SQL

Tue, 02 Mar 2010 10:46:33 GMT

Hej Philippe

The times I have used section access for users, I had to included the domain name if using NT admin e.g. DOMAIN/Userid.

Do your user ids have the domain in front?

Section Access with SQL

Mon, 17 Jan 2011 11:15:50 GMT

Hi,

I have The Same Problem, is there a solution??

Section Access with SQL

Mon, 17 Jan 2011 11:15:52 GMT

UserTable:

SELECT user AS USERID ,psswd AS PASSWORD , access AS ACCESS

FROM dashboardUsers WITH(NOLOCK);Section Access

load ACCESS,USERID, PASSWORD ;

resident UserTable:

Section Application;

There are usernames and passwords on my dashboardUsers table. But only the user that named ADMIN works. Non Of the others are working

Section Access with SQL

Mon, 17 Jan 2011 13:49:05 GMT

I tried UPPER(trim(ACCESS)) AS ACCESS , It works!

Section Access with SQL

jonathandienst — Mon, 17 Jan 2011 14:45:14 GMT

Phillipe

Maybe its just cut & paste problem, but I see no FROM statement for the

load "ADMIN" as USERID
"ADMIN" as ACCESS;

clause. Normally this causes the LOAD to use the next statement as the "from" source, but your next statement is the Section Access command, followed by the LOAD RESIDENT for the access load. I think QV might be getting confused at this point.

If that is the case

load "ADMIN" as USERID
"ADMIN" as ACCESS
FROM <where ever this data should be coming from>;

Jonathan

Section Access with SQL

amars — Mon, 17 Jan 2011 14:50:38 GMT

Hi Philippe

Security:

load UPPER(UserCode) as USERID, "USER" as ACCESS;

select * from G_USAGER;

load "ADMIN" as USERID "ADMIN" as ACCESS;

For your code to work

ACCESS, USERID, PASSWORD

These fields needs to be in a single row. From ur code it seems that the ACCESS, USERID & I hope the password comes from a third table G_USAGER needs to be in a single row. Also for concatenating the ADMIN & USER level user's try Concatenate (Security) for ADMIN access. See the table structure as well(Ctrl+T)

Thanks.