SECTION APPLICATION

[alexantone]

Hello

I have a SECTION ACCESS ==>it 's OK

I want to hide a tab  ==>So i had to add a colomn name on my section  ACCESS "VISIBLE"

my SECTION ACCESS

NTNAME id/ALEX  USER  , VISIBLE 1

NTNAME id/TOTO  USER  , VISIBLE 0

NTNAME id/SKY USER  , VISIBLE 1

my SECTION APPLICATION

what should I put?

[alexantone · Accepted solution]

hello i don't want to check initial Data reduction because
there is an issue and all my users could have the message error (no authorization ...)

thank so lot for your help but i will make a varaible (if Ouser() ='ALEX' or Ouser()='TOTO' ...

[hopkinsc]

OK. If that is all then please mark any answers as helpful or correct to close this thread. 

Thanks and good luck. 

[alexantone]

is necessary to check Strict restriction in order to use Section APPPLICATION?

[hopkinsc]

No, Strict exclusion will lock anyone who is not part of section access out of the app if there are mistakes. Read the link i provided earlier. 

Also, you should not be marking your own posts as the solution. 

[alexantone]

SECTION ACCESS;
ACCESS:

LOAD
ACCESS,
NTNAME,
VISUEL
FROM
[..\..\..\..\HABILITATIONS\Habilitations.xlsx]
(ooxml, embedded labels, table is DAMIER);

SECTION APPLICATION;

VISIBILITE:

LOAD
NTNAME,
VISUEL as LE_VISUEL
resident ACCESS where VISUEL >=0;

Is QSuser() or NTNAME is the same?
because when i published ths app , the user ALEX and the user QLIKVIEWservice are available in the VISIBILITE table (in my section access table there is Qlikviewservice it is ok)
it would be indicated only the user ALEX (with his active directory) Why the QLIKviewservice is present too?

[hopkinsc]

Where are you seeing QSuser? 

USER and NTNAME are different. NTNAME uses the AD sign in name and username could be anything. You should only have 1 populated in a row. 

i.e.

if there is a row for ALEX then he shouldnt have a username AND ntname. just 1. 

[alexantone]

when ALEX is logging with his AD
=>On accessPOINT it is indicated welcome id/ALEX==>Ok
=>but when i read on listbox the VISUEL number it is indicated 0 and 1!
when i put the table information there is id/ALEX and id/QLIKVIEWservice=>it should be indicated ONLY id/Alex

[hopkinsc]

IF ALEX is using NTNAME then he shouldn't be logging in. it should allow him in with no user intervention. 

So is he actually typing in his AD credentials to get in?

[hopkinsc]

Can you attach any examples? maybe create a test document with all of the section access in and a list box showing the VISUEL values. 

if you do that then also include a username and password so i can get access.