Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a report. Users should be access data based on DNAME.
User1 (ADMIN) should access all the data - ACCOUNTS,HR,SALES.
User2 should access HR data.
User 3 should access SALES data.
But User1 should access NULL values always.
Please update the attached file and provide.
Thanks in advance.
Hi,
If user wants to access all the values other than then use *, to access nulls just give empty.
Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD,DNAME
ADMIN,ADMIN,ADMIN,* // Access all values other than Nulls
ADMIN,USER1,USER1, // To access values
USER,USER2,USER2,HR
USER,USER3,USER3,SALES
USER,USER4,USER4,*
USER, USER4, USER4, // USER4 can Access all values including nulls
];
Section Application;
Hope this helps you.
Regards,
Jagan.
HI,
see attachment
Users/Psw
ADMIN/ADMIN
USER1/USER1
USER2/USER2
USER3/USER3
Regards,
Antonio
Hi AntonioTiman
Thank you so much.It is perfect.
Hi,
If user wants to access all the values other than then use *, to access nulls just give empty.
Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD,DNAME
ADMIN,ADMIN,ADMIN,* // Access all values other than Nulls
ADMIN,USER1,USER1, // To access values
USER,USER2,USER2,HR
USER,USER3,USER3,SALES
USER,USER4,USER4,*
USER, USER4, USER4, // USER4 can Access all values including nulls
];
Section Application;
Hope this helps you.
Regards,
Jagan.
Hi jagan
Thank you so much. It is working for NULLs also.