Hi there,
I have added couple of tables to existing application and want to restrict access to those tables for certain users only. I have tried following:
Section Access;
LOAD * INLINE [
ACCESS, NTNAME,SECURITYGROUP1, OMITGROUP1
ADMIN, QVADMIN, ALL
USER, QVUK, UK, group1
USER, QVUS, US, group1
USER, QVINCL,NONE,
];
LOAD * INLINE [
OMITGROUP1, OMIT
group1, Field1
group1, Field2
group1, Field3
group1, Field4
group1, Field5
...
];
User1 and User2 are part of QVUK AD group therefore can see all UK data. Recent addition of OMITGROUP1 to section access has restricted them to view new tables but I only wanted to restrict it for User2 and User1 should see those two tables’ data as well. I can’t do this by users as this is just an example but in reality there are quite a few users who are similar to User1 and User2.
I have created a new security group QVINCL and added User1,just to check whether not having OMIT applied to this, this may allow the required access but didn’t work. See attached file for you to play around. I have added USERUK twice to simulate above scenario where USERUK should be part of QVUK and QVINCL.
Thanks in advance.
