Current User at Section Access

Thu, 09 Jan 2014 11:46:15 GMT

Hi all,

I am trying to implement some restrictions to a "data island" at my QV application,

My application is restricted by Section access as seen bellow:

Section Access;
set HidePreffix = '_';

LOAD * INLINE [
    ACCESS, NTNAME, PASSWORD, _GRUPO, _GRUPO1, _GRUPO2
    ADMIN, ARQUIVOS\SUPORTE_TI, *, ADM, ADM, ADM
];

LOAD DISTINCT
  'ADMIN' as ACCESS,
  'DOMAIN\' & upper(trim(USU_LOGIN)) as NTNAME,
  '*'  as PASSWORD,
  If(upper(trim(USU_TIPREP)) = 'RTV', upper(trim(USU_LOGIN)), 'ADM') as _GRUPO,
  If(upper(trim(USU_TIPREP)) = 'SR', upper(trim(USU_LOGIN)), 'ADM') as _GRUPO1,
  If(upper(trim(USU_TIPREP)) = 'GCR', upper(trim(USU_LOGIN)), 'ADM') as _GRUPO2
FROM [..\TRA\REF\Usuario.QVD] (qvd);

Section Application;

I am applying those restrictions at Load time as you can see:

USUARIO_ATUAL:
noConcatenate
LOAD DISTINCT
  [Usuário] AS aUsuario,
  Login AS aLogin,
  Nome AS aNome,
  Tipo AS aTipo,
  Codigo AS aCodigo,
  Supervisor AS aSupervisor,
  Gerente AS aGerente,
  ADM AS aADM
FROM
  [..\TRA\REF\LogAcesso.qvd](qvd)
WHERE
  [Usuário]=Upper(OSUser());

LOG_ACESSOS_RTV:
NoConcatenate
LOAD
  *
FROM
  [..\TRA\REF\LogAcesso.qvd]
(qvd);
INNER JOIN
LOAD
  aCodigo AS Codigo
RESIDENT USUARIO_ATUAL
WHERE aTipo='RTV';

To get the current user I am using OSUser() function. It works at development time, but obviously do not works at server time. Doing a call to QVUser() function, it does not works too, cause my section access do not contains USERID field.

So, how can I get the current user logged in at QV access point to my QV application?

Thanks in advance

Re: Current User at Section Access

hic — Thu, 09 Jan 2014 12:07:30 GMT

You shouldn't make a restriction that way. Instead, you could add the field USUARIO to both the USUARIO_ACTUAL table and to the authorization table in Section Access. Then the reduction will be made automatically when the user opens the app. Make sure you use upper case in both tables.

You need to check the "Initial data reduction ..." under Document Properties -> Opening also.

HIC

Re: Current User at Section Access

Tue, 14 Jan 2014 16:28:38 GMT

By some reasons and a complex user section access I cannot reduce my data.

I am using initial section selection by document properties option.

By the way, thanks in advance. I solve the problem using Set Analysis at my "data island" to charts with aggregation and straight table.

topic Re: Current User at Section Access in QlikView

Current User at Section Access

Re: Current User at Section Access

Re: Current User at Section Access