Multiple profiles in Section Access

Wed, 14 Apr 2010 08:27:21 GMT

Can you help please

I create multiple profiles in Section access files:
I have more users.
Each user has permission to see only some values of specified fields. An example
Mario Rossi can see the value "ZS2" for the field AURAT ,
all those starting with "ZW" (identified by ZW*)
all values from 0 to ZOF (0,ZOF),
all values from ZOH to ZZZZ (ZOH ,ZZZZ)

USERNAME

FIELD

LOW

HIGH

Mario Rossi	AUART	ZS2
Mario Rossi	AUART	ZW*
Mario Rossi	AUART	0	ZOF
Mario Rossi	AUART	ZOH	ZZZZ

Multiple profiles in Section Access

stevedark — Wed, 14 Apr 2010 10:50:59 GMT

Hi Adrea,

You can load your section access statement from the same data source as the rest of the data is coming from. I suspect you could therefore fashion a select statement that returned a row for each value that Mario could see?

For SQL Server it would be something a bit like:

SELECT
'Mario Rossi' as USERNAME,
AUART
FROM SourceTable
WHERE
AUART = 'ZS2'
OR AUART LIKE 'ZW%'
OR AUART BETWEEN '0' AND 'ZOF'
OR AUART BETWEEN 'ZOH' AND 'ZZZZ'

UNION ALL

SELECT
'Someone Else' as USERNAME ,
.....

The most tidy way of doing this would probably be to build the logic for the security into a view, so a more simple select statement would appear in your load script.

Hope that helps.

Regards,
Steve

topic Multiple profiles in Section Access in QlikView

Multiple profiles in Section Access

Multiple profiles in Section Access