Control access management console

frinfo — Wed, 26 Sep 2018 16:49:35 GMT

Hi everyone,

i've a problem with a section access in my .qvw.

I create this section access in the script:

sub CaricaSectionAccess2

UtentiCapoAreaSA:

NoConcatenate

load Distinct

trim([Key Agente Riferimento Cliente]) as [Key Agente Riferimento Cliente SA],

trim([Key Agente Cliente Codice]) as [Key Agente Cliente Codice SA]

resident AgentiClienti

where [Key Agente Riferimento Cliente] <> '' and not isnull([Key Agente Riferimento Cliente]);

MapKeyAgenteNomeUtente:

mapping load

trim(DITTA) & '-' & trim(CODICE_AGENTE) as [% Key MapKeyAgenteNomeUtente],

trim(UTENTE) as [% Value MapKeyAgenteNomeUtente]

FROM

Dati\utenti_ruoli.xls

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

Ruoli:

LOAD

trim(RUOLO) as RUOLO,

trim(PRINCIPALE) as PRINCIPALE,

trim(VENDITE) as VENDITE,

trim(ACQUISTI) as ACQUISTI,

trim(ORDINICLIENTI) as ORDINICLIENTI,

trim(ORDINIFORNITORI) as ORDINIFORNITORI,

trim(BUDGET) as BUDGET,

trim(AGENTI) as AGENTI,

trim(MAGAZZINO) as MAGAZZINO,

trim(PRODUZIONESEDE) as PRODUZIONESEDE,

trim(REPORTDINAMICO) as REPORTDINAMICO,

trim(DASHBOARD) as DASHBOARD,

trim(SALES) as SALES

FROM

Dati\utenti_ruoli.xls

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

section access;

Access:

LOAD * INLINE [

ACCESS,NTNAME,IDAGENTE,AZIENDAID,RUOLO

ADMIN,PIPPO\USER1,*,*,SUPERUSER

ADMIN,PIPPO\USER2,*,*,SUPERUSER

ADMIN,PIPPO\USER3,*,*,SUPERUSER

ADMIN,PIPPO\USER4,*,*,SUPERUSER

ADMIN,PIPPO\USER5,*,*,SUPERUSER

ADMIN,PIPPO\USER6,*,*,SUPERUSER

];

TabSA:

load Distinct

IDAGENTE as IDAGENTE_SA

resident AgentiClienti;

join (TabSA)

load Distinct

AZIENDAID as AZIENDAID_SA

Resident Aziende;

join (TabSA)

load Distinct

RUOLO as RUOLO_SA

Resident Ruoli;

Concatenate(Access)

load

'ADMIN' as ACCESS,

'PIPPO\USER1' as NTNAME,

IDAGENTE_SA as IDAGENTE,

AZIENDAID_SA as AZIENDAID,

//CODICEFAMIGLIAID_SA as CODICEFAMIGLIAID,

//CODGRUPPOSTATISTICO1ID_SA as CODGRUPPOSTATISTICO1ID,

RUOLO_SA as RUOLO

resident TabSA;

Concatenate(Access)

LOAD

trim(TIPO_UTENTE) AS ACCESS,

trim(UTENTE) as NTNAME,

(

len(trim(CODICE_AGENTE)) = 0,

'*',

trim(DITTA) & '-' & trim(CODICE_AGENTE)

) as IDAGENTE,

if(len(trim(DITTA)) = 0,'*',trim(DITTA)) as AZIENDAID,

//if(len(trim(CODICE_FAMIGLIA)) = 0,'*',trim(CODICE_FAMIGLIA) ) as CODICEFAMIGLIAID,

//if(len(trim(CODICE_GRUPPO_STATISTICO1)) = 0,'*',trim(CODICE_GRUPPO_STATISTICO1)) as CODGRUPPOSTATISTICO1ID,

trim(RUOLO) as RUOLO

FROM

Dati\utenti_ruoli.xls

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

concatenate(Access)

load

'USER' as ACCESS,

ApplyMap('MapKeyAgenteNomeUtente',[Key Agente Riferimento Cliente SA],'NOAG') as NTNAME,

[Key Agente Cliente Codice SA] as IDAGENTE,

SubField(trim([Key Agente Riferimento Cliente SA]),'-',1) as AZIENDAID,

//'*' as CODICEFAMIGLIAID,

//'*' as CODGRUPPOSTATISTICO1ID,

'AGENTE' as RUOLO

resident UtentiCapoAreaSA

order by [Key Agente Riferimento Cliente SA]

;

section Application;

end sub

after i've publish the file in my WebServer and i make a reaload with administrator user in managment console.

i've set on the objects of my sheet the visibility trought an ACL based on user defined in the .xls, but every user can see all the objects.

What could it be the problem?

Thanks in advance.

topic Control access management console in QlikView

Control access management console