Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
i have an app with lot of tables related to a master table with information about sales products.
Each product get assigned his brand.
I'd like that "USER01" can only see data about products of brand "BRAND01", and all the other users can see everything.
I have seen posts talking about Section Access, but i'm not able to know how to solve my problem using Section Access.
Is there any way to do this?
Thanks!
Hi @asanfelix
This post by @Dalton_Ruer is probably the best I've seen on the topic. I would recommend working through the PDF and getting an understanding of how section access works before implementing it, otherwise you'll just be guessing. I'm sure his example will help.
Regards,
Mauritz
section access is pretty simple - I'll take your example for using BRAND01. You want to figure out what your domain and user id is by going into your QMC. Essentially there are 2 parts. Section Access and Section Application. Under the Section Access, you can see I have 3 columns. You must always include the "ADMIN, INTERNAL\SA_SCHEDULER". I added yourself as an Admin since I'm assume you'd want to see all the data, but loaded a regular "user" for the user that should see only BRAND01. The "1" under the "user" line denotes that that user should only see data pertaining to BRAND01. I created a linkage through PRODUCTID as you can see in the script below. If you want to restrict other brands from other users, you can just sequentially add rows underneath the section application script with the the updated brands and add the respective productid number to the section access piece (part 1 of the Section Access). Hope this helps and sheds light. One last thing - make sure your data here is all uppercased.
SECTION ACCESS;
LOAD * INLINE [
ACCESS, USER_ID, PRODUCTID
ADMIN, domain\*YOUR ID FOUND FROM QMC*, ,
USER, domain\*YOUR USER*, 1
ADMIN, INTERNAL\SA_SCHEDULER,*,
];
SECTION APPLICATION;
LOAD * INLINE [
PRODUCTID, PRODUCT
1, BRAND01
];
Hi @asanfelix
This post by @Dalton_Ruer is probably the best I've seen on the topic. I would recommend working through the PDF and getting an understanding of how section access works before implementing it, otherwise you'll just be guessing. I'm sure his example will help.
Regards,
Mauritz
section access is pretty simple - I'll take your example for using BRAND01. You want to figure out what your domain and user id is by going into your QMC. Essentially there are 2 parts. Section Access and Section Application. Under the Section Access, you can see I have 3 columns. You must always include the "ADMIN, INTERNAL\SA_SCHEDULER". I added yourself as an Admin since I'm assume you'd want to see all the data, but loaded a regular "user" for the user that should see only BRAND01. The "1" under the "user" line denotes that that user should only see data pertaining to BRAND01. I created a linkage through PRODUCTID as you can see in the script below. If you want to restrict other brands from other users, you can just sequentially add rows underneath the section application script with the the updated brands and add the respective productid number to the section access piece (part 1 of the Section Access). Hope this helps and sheds light. One last thing - make sure your data here is all uppercased.
SECTION ACCESS;
LOAD * INLINE [
ACCESS, USER_ID, PRODUCTID
ADMIN, domain\*YOUR ID FOUND FROM QMC*, ,
USER, domain\*YOUR USER*, 1
ADMIN, INTERNAL\SA_SCHEDULER,*,
];
SECTION APPLICATION;
LOAD * INLINE [
PRODUCTID, PRODUCT
1, BRAND01
];