topic security by data level in QlikView

security by data level

jasonseril — Mon, 17 Aug 2009 12:34:19 GMT

Hi,

I just want to ask if we can have security by data level using section access or the like? A particular user can only access specific data in a table. Does anybody has a sample QV application for this issue.

Thanks

security by data level

amars — Mon, 17 Aug 2009 13:20:20 GMT

Hi,

See if this example helps , the user's for it are

ACCESS, USERID, PASSWORD, COMPANY,OFFICE

ADMIN, ADMIN, ADMIN, ,

USER, POWERUSER, LETMEIN, , OFFICE_X

USER, ABC, ABC, X , OFFICE_X

USER, XYZ, XYZ, Y ,OFFICE_Y ];

See if this helps.

Regard's

Amar

security by data level

jasonseril — Mon, 17 Aug 2009 13:49:11 GMT

Hello,

Thank you very much Amar. This is very helpful in the inquiry i posted.

regards,

jason

security by data level

jasonseril — Mon, 17 Aug 2009 14:14:12 GMT

Hi,

By the way Amar, how come POWERUSER cannot access the document? did i miss something. thanks again.

jason

security by data level

amars — Mon, 17 Aug 2009 15:11:45 GMT

(Sorry my mistake) Use * instead of blank space

USER, POWERUSER, LETMEIN,* , OFFICE_X

Regard's

Amar

security by data level

jasonseril — Mon, 17 Aug 2009 15:18:39 GMT

ok, copy. thanks again Amar, for the quick reply.

I have one last question for this post, can we have security by menu level? like, one user cannot access certain submenu (i.e edit script) while other user can open edit script. thanks

regards,

jason