Authentication for data reduction not working

[nsm1234567]

Hi there,

I'm hoping someone might be able to assist me.  I can't get the data in this model to reduce the way I want it to.  What I want is that, when the "User" logs in, they only see the "Branch" Project.  The login details for both "admin" and "user" are "admin123".  Password for the hidden script is password.

Can someone please check where I'm going wrong?

Thanks for your assistance.

[maxgro]

use uppercase

set strict exclusion in settings --> document properties-->opening

[fashid]

Hi,

Please mark the question as answered if this is what you were looking for . It encourages others to answer questions.

Regards,

Nadeem

[nsm1234567]

Hey There, thanks for this.  Why though, when the admin user logs in, can they only view branch data until such time as the model is reloaded (at which point the admin user can see all the projects)?  Should the admin not be able to see all of the projects?

[maxgro]

add other project for ADMIN if ADMIN needs to see other project (LIFESTYLE in example below)

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, PROJECT

    ADMIN, ADMIN, ADMIN123, *

    USER, USER, ADMIN123, BRANCH

    ADMIN, ADMIN, ADMIN123, LIFESTYLE   

];

[maxgro · Accepted solution]

A wildcard, i. e. *, is interpreted as all (listed) values of this field (PROJECT field), i.e. a value listed elsewhere in this table.

[nsm1234567]

Ah ok, that makes sense.  So I can theoretically create a dummy "user" that has access to each project and then the "wildcard" will work as I'm expecting it to?  Seems a bit strange, but thanks for the help.