Section Access can't work to show all if user as USER.

[#1]

Why i can't enter qvw if i login with section access as horasi? but i can access with user danny, wto, or user3.

I want to see all data without any filter by TYPE_RGM.

This is my code :

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, TYPE_RGM

    ADMIN, ADMIN, ADMIN

    USER, horasi, P@ssw0rd

    USER, danny, P@ssw0rd, NOM DIRECT 1

    USER, wto, P@ssw0rd, NOM DIRECT 2

    USER, user3, P@ssw0rd, *

];

Section Application;

May be someone can help me,

Thanks.

Danny H

[jvitantonio]

Try adding ,*

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, TYPE_RGM

    ADMIN, ADMIN, ADMIN

    USER, horasi, P@ssw0rd,*

    USER, danny, P@ssw0rd, NOM DIRECT 1

    USER, wto, P@ssw0rd, NOM DIRECT 2

    USER, user3, P@ssw0rd, *

];

[swuehl]

Danny,

please note the usage of the star symbol * in data reduction.

horasi will have access to all records with TYPE_RGM equals 'NOM DIRECT 1' or 'NOM DIRECT 2', i.e. all values listed in the section access table, not all values that are in the section application table with same field name.

[#4]

TYPE_RGM is more than 2 value (like NOM DIRECT 1 and NOM DIRECT 2).

There is have NOM MM, NOM RC, etc. I want to get this value if I login as horasi.

May be someone can give me more explain? I want to access user horasi in Qlikview server also

Thanks

[jvitantonio]

Did you ty adding * ?

[#6]

I have try using *, but I only get NOM DIRECT 1 and NOM DIRECT 2 only. I want to get another value in field TYPE_RGM.

My be I must add some code to repair my section access?

[jvitantonio]

Oh , ok I got you mean. You need to add 1 more line to your section access saying what other value for TYPE_RGM you want to that user to see:

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, TYPE_RGM

    ADMIN, ADMIN, ADMIN

    USER, horasi, P@ssw0rd,*

        USER, horasi, P@ssw0rd,NOM DIRECT 3 //this is the new line you need to add

    USER, danny, P@ssw0rd, NOM DIRECT 1

    USER, wto, P@ssw0rd, NOM DIRECT 2

    USER, user3, P@ssw0rd, *

];

In this example you make user horasi see NOM DIRECT 1, NOM DIRECT 2 and you also add a new line so he sees NOM DIRECT 3

If you need him to see other TYPE_RGM you just add another line with the new TYPE_RGM.

I hope this helps.

[stevedark]

In order to keep Section Access secure the * only refers to other values that are referenced in your Section Access table.  This is intended functionality - but it can sometimes be problematic.  The code referenced above will work to allow user3 access to DIRECT 3, but not any new items that appear.

Often I will do the section access as above, and then load in the scope for the secured fields in a separate statement, eg:

Temp_Scope:

LOAD

     TYPE_RGM

FROM Data.qvd (qvd)

GROUP BY TYPE_RGM;

Section Access;

[Main Section Access Here]

LOAD

     '-No Access-' as ACCESS,

     '-No Access-' as USERID,

     '-uI8~90h#kDF9¬ahldf899-' as PASSWORD,

     TYPE_RGM

RESIDENT Temp_Scope;

Section Application;

DROP TABLE Temp_Scope;

This way you can guarantee that all values appear somewhere in the Section Access and * will therefore do what you want it to do.

Hope that helps.

Steve

http://www.quickintelligence.co.uk/

[#9 · Accepted solution]

I have found this result. I must join with all of data in field TYPE_RGM.

This is my code :

Criteria:

LOAD Distinct TYPE_RGM

FROM

msCriteria.qvd

(qvd);

Section Access;

LOAD ACCESS,

     USERID,

     PASSWORD,

     TYPE_RGM

FROM

[Section Access.xls]

(biff, embedded labels, table is Sheet1$);

join

LOAD TYPE_RGM

Resident Criteria;

Section Application;

Drop Table Criteria;