omit doesn't work

[#1]

hi

i try the following example . and connect as user1 .

this user not have permission to see Field1 or Field2 , but for some reason he still can these fields . why ?

do i need to define something in Document level so the OMIT will work ?

thank you .

Section Access;

LOAD * INLINE [

    ACCESS, USERID, OMITGROUP

    ADMIN, admin,

    USER, user1, group1

    USER, user2, group2

];

LOAD * INLINE [

    OMITGROUP, OMIT

    group1, Field1

    group1, Field2

    group2, Field2

    group2, Field3

];

Section Application;

Fields:

LOAD * INLINE [

    Field1, Field2, Field3, Field4, Field5

    Value1, Value2, Value3, Value4, Value5

];

[tresesco]

Sorry, i should have been more careful.

Remove the JOIN and try.

[sudeepkm]

I'm using version 11.0.11426.0 64bit and your code works fine for me.

[#4]

maybe i missing something here.

i run the qvw via  batch file , and he he ask me for user , and i insert select 'admin' .

then when i open the qvw  it did not ask for user name why ?

maybe this is the problem ?

BTW : i try to do it (batch file) also with user1 an 2

[swuehl]

What do you mean with batch file? A windows script .bat file that calls the QV executable?

How does it look like?

In principle, your code seems to work for me.

Two possible issues:

- If you want to test with different users, I believe you need to close the QV Windows application inbetween, otherwise your credentials will be remembered.

- Take care not to save the file after opening with e.g. user1, then trying to check user2. After opening with user1, your data model will be reduced to the fields allowed for user1.

If you then save and reopen with user2, only fields 3-5 are contained in your model, field3 is removed and so user2 will only see field 4 &5. That's what I see in your attached app.

--> Do a reload as admin, save the file, then don't save it again as a different user!

[#6]

Thank you

i follow your instruction and it work good

it seem the problem was that i did not close all the open QV and sometime i save as user.

BTW :  see attach how to reload via script .bat file

it is faster and do not stuck you windows applications

"C:\Program Files\QlikView\qv.exe" /r                                   = the location where you QV exe install

"C:\SHARON\QlikView\Work_With_Permissions\bbb.qvw"     = your qvw you want to run

[#7]

Hi

after we see that it work i would like to add some restriction

I want that user1 will not see columns Field1, Field2 and will see data only his region (AA)

i try something and it didn't work for user only for admin . - see attach

do you have any idea ?

thank you

[swuehl]

Your values for REGION in section access and section application don't match (AA vs AAA).

[#9]

you right my mistake

[#10]

yes it work for me too

thank you