Secton access

[denis115]

hello!

I need your help!

I've tryied a script to give access to each person for different prodtype

Section Access;

LOAD * INLINE [

    ACCESS, NTNAME,  PRODTYPE

    ADMIN, user1, JOB

    ADMIN, user2 ,HOME

];

Section Application;

but when I reload my file ,there are no changes, each of this two admins can see both PRODTYPES

help me please!

[neha_shirsath]

First check you have enabled the setting in Document Properties tab >  Opening > Initial data reduction....

Section Access;

LOAD * INLINE [

ACCESS, NTNAME, PRODTYPE 

USER, USER1 , WOOD

USER, USER2 , MEAT

USER, USER3,GOLD

ADMIN, USER4 , *    //Here * means PRODTYPE listed below inline

];

Section Application;

load * inline [

PRODTYPE

WOOD

MEAT

GOLD

];

[denis115]

nothing changed...

[neha_shirsath]

Check the attached file.

I'm using below code and it is working-

Section Access;

LOAD * INLINE [

ACCESS, NTNAME, PRODTYPE

USER, USER1 , WOOD

USER, QV.SUPPORT6 , MEAT

USER, USER3,  GOLD

ADMIN, ADMIN , *   

];

Section Application;

load * inline [

PRODTYPE

WOOD

MEAT

GOLD

];

[MK9885]

select
PRODID,
PRODTYPE AS  "Сбыт Группа",
PRODTYPE3 AS  "Сбыт Направление",
PRODNAME AS  "Наименование Продукта",
AT2NAME AS  "Товарная Группа",
AT3NAME AS  "Товарная Подгруппа",
AT5NAME AS  "Бренд" ,
NOMENCLATURE_STATUS_ID AS  "Статус ИД ТМЦ"

FROM VBNZ.PRODUCTS
where MODIFIED>='01.JAN.2016'
;

hidden script :

Star is *;

Section Access;
LOAD * INLINE [
ACCESS, NTNAME, Сбыт Группа
 
USER, USER1 , WOOD

USER, USER2 , MEAT

USER, USER3,GOLD
ADMIN, USER4 , *
];
Section Application;

You are changing the field name from PRODTYPE  to "Сбыт Группа" and the section access would look for PRODTYPE which is not available...change it to the new field name you've given?

And I gues you already know NTname is Domain name. Ex- Domain\User1 but not just User1.

[denis115 · Accepted solution]

Problem is solved!

After closing and opening my qvw file, everything worked great!

Thank you!

[Anonymous]

Which solution u have used ,kindly mark it as  useful so that , who are facing the same type of issue it will be useful for them

Thanks,