Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi i am doing section access in sense server
like this
section access;
load * inline [
ACCESS, USERID, COMPANY_CODE
USER, DOMAIN\arul.settu, 001
];
Section Application;
it worked once. after i tried to include more company for same user not working.
any ideas?
Thanks
try
section access;
load * inline [
ACCESS, NTNAME, COMPANY_CODE
USER, DOMAIN\arul.settu, 001
];
Section Application;
Also not sure but you can make
section access;
load ACCESS, UPPER(NTNAME), COMPANY_CODE inline [
ACCESS, NTNAME, COMPANY_CODE
USER, DOMAIN\arul.settu, 001
];
Section Application;
try lik below
section access;
LOAD * inline [
ACCESS, USERID,REDUCTION, OMIT
USER, AD_DOMAIN\ADMIN,*,
USER, AD_DOMAIN\A,1,
USER, AD_DOMAIN\B, 2,NUM
USER, AD_DOMAIN\C, 3, ALPHA
USER, INTERNAL\SA_SCHEDULER,*,
];
section application;
Could you share a sample qvf with representative data?
bro i tried both but not working. it showing all company details
not allowed to share data
On my end:
section access;
LOAD * inline [
ACCESS, USERID,REDUCTION,
USER, DOMAIN\Me,*
USER, DOMAIN\User2, 2
USER, DOMAIN\User3, 3
USER, INTERNAL\SA_SCHEDULER,*
];
section application;
T1:
LOAD *,
NUM AS REDUCTION;
LOAD
Chr( RecNo()+ord('A')-1) AS ALPHA,
RecNo() AS NUM
AUTOGENERATE 3;
Produces:
This:
section access;
LOAD * inline [
ACCESS, USERID,REDUCTION,
USER, DOMAIN\Me,1
USER, DOMAIN\User2, 2
USER, DOMAIN\User3, 3
USER, INTERNAL\SA_SCHEDULER,*
];
section application;
T1:
LOAD *,
NUM AS REDUCTION;
LOAD
Chr( RecNo()+ord('A')-1) AS ALPHA,
RecNo() AS NUM
AUTOGENERATE 3;
Produces:
And this:
section access;
LOAD * inline [
ACCESS, USERID,REDUCTION,
USER, DOMAIN\Me,1
USER, DOMAIN\Me,2
USER, DOMAIN\User2, 2
USER, DOMAIN\User3, 3
USER, INTERNAL\SA_SCHEDULER,*
];
section application;
T1:
LOAD *,
NUM AS REDUCTION;
LOAD
Chr( RecNo()+ord('A')-1) AS ALPHA,
RecNo() AS NUM
AUTOGENERATE 3;
Produces:
So I am not quite seeing what you're describing.