Section access issue for the user to login

[manoranjan_d]

Hi all,

In the hidden script below i have coded

Section Access;

LOAD * INLINE [

    ACCESS, USERID, REVIEW_FLAG

    ADMIN, X113861, Yes

    ADMIN, X113861, No

    ADMIN, A015681, Yes

    ADMIN, A015681, No

    USER, X113547, Yes

  ];

Section Application;

in the main tab

T1:

LOAD Month, REVIEW_FLAG

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

As a admin i can able to log on and view both flag Yes and No

But as user i can't login , its showing as access denied, can you help me on this

I checked all the ways by selecting the initial data reduction int he settings but the user(X113547) can't able to open.

i have attached the file and sample data,to open  hidden script password is test.

[kaushiknsolanki]

Hi,

Make sure you give the password field also.

Regards,

Kaushik Solanki

[manoranjan_d]

as per my requirement my client don't want the password..

[fvelascog72]

Hi,

Strict Exclusion

If this check box is marked in combination with Initial Data Reduction Based on Section Access, strict exclusion will be used when reducing the data. This means that access to the document will be denied whenever the field values in the section access reduction fields lack matches in their corresponding section application field. This, however, does not apply for users with Admin status, who instead will see the unreduced data set if there are no matches.

USER, X113547, Yes

Hope it helps

[kaushiknsolanki]

What is the password for the hidden script.

Regards,

Kaushik Solanki

[manoranjan_d]

TEST is the password

[manoranjan_d]

hi there is Yes value in the REVIEW_FALG field, pls see the qvw file and sample data file

[PrashantSangle]

Hi,

both field value must be in upper.

Use upper(REVIEW_FLAG) as REVIEW_FLAG

and try

Regards

[Peter_Cammaert · Accepted solution]

Are you testing this in QV Desktop or on a server?

I guess it's the former and you probably get in using the first few accounts because of them being ADMINs. Most probably, there isn't any value linking from SectionAccess to Section Application.

A first change I would implement is to not only put the link field name in upper case, but also the values in both Section Access and Section Application. E.g. in your hidden script, change the load into something like:

LOAD * INLINE [

ACCESS, USERID, REVIEW_FLAG

ADMIN, X113861, YES

ADMIN, X113861, NO

ADMIN, A015681, YES

ADMIN, A015681, NO

USER, X113547, YES

];

and change the link values in your Excel as well. In Section Access this isn't really necessary because the Section Access code will do that automatically anyway. But doing this in SA too will make you pay attention.

AFAIK you don't need passwords if you don't want to. But in that case security will be non-existent...

[fvelascog72]

Uncheck strict exclusion.

I tried and works