Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Not applicable

Section Access

I have to provide Section Access with multiple fields as below. This is the user access list. How can this be done using the section access?

field

field1field2field 3UserHeader 5
sla1legacymptuser1
sla2legacymptuser1
sla3sap crmrmsuser1
sla4go solutionrmsuser2
sla5ordarmsuser2
sla6ordamhsuser2
sla8mdivmhsuser2
sla9siebelmptuser3
4 Replies
MVP
MVP

Re: Section Access

fabio182
Contributor

Re: Section Access

Hola Anita tienes que realizar algo como lo siguiente:

//*******************************************************************************************

//Seguridad por Pestaña

Section Access;

SATABLE:

LOAD ACCESS,

     NTNAME,

     SAUSER

FROM

..\Include\Seguridad_Acceso_Hojas_Manufactura.xlsx

(ooxml, embedded labels, table is ListaUsuarios);

Section Application;

star is *;

LOAD SAUSER,

     CTE,

     CTI,

     CTT,

     CV,

     ManoObraDirecta,

     ManoObraTotal,

     EficienciaMecanica,

     UsodeCapacidad,

     RendimientodeInsumos,

     EjecutadovsProgramadoEmbotellado,

     [Calidad(ProductoNoDefectuoso)Inyeccion],

     [Calidad(ProductoNoDefectuoso)Tapas],

     AccidentabilidadPlantaEmbotellado,

     UtilizaciondeEnergiaElectricaEmbotellado,

     CostodelMantenimiento,

     UtilizaciondeAguaCrudaEmbotellado,

     AseguramientodelaCalidad,

     RotaciondeInventariosRefacciones

FROM

..\Include\Seguridad_Acceso_Hojas_Manufactura.xlsx

(ooxml, embedded labels, table is ListaUsuarios);

//*******************************************************************************************

ACCESSNTNAMESAUSERCTECTICTTCVManoObraDirectaManoObraTotalEficienciaMecanicaUsodeCapacidadRendimientodeInsumosEjecutadovsProgramadoEmbotellado Calidad(ProductoNoDefectuoso)InyeccionCalidad(ProductoNoDefectuoso)TapasAccidentabilidadPlantaEmbotelladoUtilizaciondeEnergiaElectricaEmbotelladoCostodelMantenimientoUtilizaciondeAguaCrudaEmbotelladoAseguramientodelaCalidad  RotaciondeInventariosRefacciones
ADMINAJEGROUP\PE3DEV1AJEGROUP\PE3DEV1111111111111111111
ADMINAJEGROUP\PE3DEV8AJEGROUP\PE3DEV8111111111111111111
ADMINAJEGROUP\QVSERVERAJEGROUP\QVSERVER111111111111111111

Espero te pueda ayudar.

Not applicable

Re: Section Access

Unfortunately I dont understand Spanish dear... but I am trying my best to understand the concept from what you have written.. Really appreciate your help.

carlos_reyes_qv
Valued Contributor

Re: Section Access

The post from HC pubished by Massimo is the way to go! I had a similar issue some time ago and the method described by Henric it's the best I've found so far.

Community Browser