Hi,
In my app I have defined section access based on user login. without publisher its working but in our prod evn scheduled are happening thru Publisher. there i'm facing problem. Super user who has configured admin and configured with '*' to see complete view. when I logged with super it is working but with sub users who has configured for a particular section of data view is not working. when I logged in any sub user Access point itself getting logged out automatically..
Pls. advice if there special configuration to be set at Publisher level.
Thanks In Advance!
Br, Balanandam
In my app I have defined section access based on user login. without publisher its working but in our prod evn scheduled are happening thru Publisher. there i'm facing problem. Super user who has configured admin and configured with '*' to see complete view. when I logged with super it is working but with sub users who has configured for a particular section of data view is not working. when I logged in any sub user Access point itself getting logged out automatically..
What is the mean of Highlight one. Can you share script?
Hi Anil,
this was my code
Section Access;
LOAD *, Upper(NTNAME) as User;
LOAD * INLINE [
ACCESS, NTNAME
ADMIN,EC2AMAB-7GFRL3S\ADMINUSER
USER,EC2AMAB-7GFRL3S\USER1
USER,EC2AMAB-7GFRL3S\USER2
USER,EC2AMAB-7GFRL3S\USER3
USER,EC2AMAB-7GFRL3S\USER4
];
Section Application;
star is *;
User_Reduction_Data:
LOAD * Inline [
CompanyName, User
Valutech,EC2AMAB-7GFRL3S\USER1
EncoreRepair,EC2AMAB-7GFRL3S\USER2
EcoRenew,EC2AMAB-7GFRL3S\USER3
CVE,EC2AMAB-7GFRL3S\USER4
*,EC2AMAB-7GFRL3S\ADMINUSER
];
star is *;
here I'm calling ADMINUSER as super user and rest all sub user..
My dev environment it is working but not in prod, only change is Prod we have publisher that's it.
Br, Balanandam
Can you take away star is * and check one more time, Usually star is * will work up on data reduction level for all Users and Admin as well. It won't work as expected.
Anil,
I 've changed my code like below:
Section Access;
LOAD *, Upper(NTNAME) as User;
LOAD * INLINE [
ACCESS, NTNAME
ADMIN,EC2AMAB-7GFRL3S\ADMINUSER
USER,EC2AMAB-7GFRL3S\USER1
USER,EC2AMAB-7GFRL3S\USER2
USER,EC2AMAB-7GFRL3S\USER3
USER,EC2AMAB-7GFRL3S\USER4
];
Section Application;
User_Reduction_Data:
LOAD * Inline [
CompanyName, User
Valutech,EC2AMAB-7GFRL3S\USER1
EncoreRepair,EC2AMAB-7GFRL3S\USER2
EcoRenew,EC2AMAB-7GFRL3S\USER3
CVE,EC2AMAB-7GFRL3S\USER4
CVE,EC2AMAB-7GFRL3S\ADMINUSER
EcoRenew,EC2AMAB-7GFRL3S\ADMINUSER
EncoreRepair,EC2AMAB-7GFRL3S\ADMINUSER
Valutech,EC2AMAB-7GFRL3S\ADMINUSER
];
No change on behaviour, only no problem with super user. FYI all sub users created newly and granted licenses. Is there any thing that can cause this issue ? it might be foolish ask! but I just wanted to tell you this.
with sub I can log into access point and there I can see accessible Dash board, when I can click on the Dashboard it is getting logged out.
Br, Balanandam
Hi Balanadam, to use reduction try this format..
Section Access;
LOAD * inline [
ACCESS, USERID, REDUCTION
ADMIN, DOMAIN\USER1, USER1
USER, DOMAIN\USER2, USER2
USER, INTERNAL\SA_SCHEDULER,,,*
];
Section Application;
Star is *;
REDUCT:
Load * InLine [
REDUCTION, CONTRY
USER1, *
USER2, USA
];
No Luck again!
Br, Balanandam
Instead, Can you try simple and test from Prod using below.
LOAD *, Upper(NTNAME) as User;
LOAD * INLINE [
ACCESS, NTNAME, CompanyName
ADMIN,EC2AMAB-7GFRL3S\ADMINUSER, *
USER,EC2AMAB-7GFRL3S\USER1, Valutech
USER,EC2AMAB-7GFRL3S\USER2, EncoreRepair
USER,EC2AMAB-7GFRL3S\USER3, EcoRenew
USER,EC2AMAB-7GFRL3S\USER4, CVE
];
Anil, I changed this way as suggested
Section Access;
LOAD *, Upper(NTNAME) as User;
LOAD * INLINE [
LOAD * INLINE [
ACCESS, NTNAME, CompanyName
ADMIN,EC2AMAB-7GFRL3S\ADMINUSER, *
USER,EC2AMAB-7GFRL3S\USER1, Valutech
USER,EC2AMAB-7GFRL3S\USER2, EncoreRepair
USER,EC2AMAB-7GFRL3S\USER3, EcoRenew
USER,EC2AMAB-7GFRL3S\USER4, CVE
];
Section Application;
Now I was able to login with sub users, but data reduction not happening, means Section access not working at all and I could see all the data as like ADMINUSER.
Br, Balanandam
I believe try from very static level and advance we can try. Can you check this?
LOAD * INLINE [
ACCESS, USERID, PASSWORD, CompanyName
ADMIN,EC2AMAB-7GFRL3S\ADMINUSER, 123, *
USER,EC2AMAB-7GFRL3S\USER1, 456, Valutech
USER,EC2AMAB-7GFRL3S\USER2, 789, EncoreRepair
USER,EC2AMAB-7GFRL3S\USER3, 012, EcoRenew
USER,EC2AMAB-7GFRL3S\USER4, 013, CVE
];