Section Access

[ireshaimali890]

I have added new companies, but they are still not showing. However, when I comment out the Section Access, I can view all companies. So, I have identified that the issue is with Section Access.

Can you please help me to resolve this issue? The problem is as follows:

Section Access;
LOAD
"USERID",
"ACCESS",
KEY
FROM [lib://XXX.txt]
(txt, codepage is 28591, embedded labels, delimiter is ',', msq);

Section Application;
Data_Deduction:
Load * Inline [
KEY,ORGANIZATION_ID
201,201
202,202
203,203
204,204
205,205
206,206
207,207
208,208
209,209
243,243
244,244
245,245
246,246
247,247
248,248
249,249
250,250
263,263
264,264
265,265
266,266
267,267
363,363
712,712
713,713
714,714
715,715
716,716
717,717
752,752
754,754
756,756
793,793
832,832
834,834
852,852
853,853
855,855
872,872
932,932
935,935
937,937
939,939
953,953
992,992
1032,1032
1072,1072
1132,1132
1152,1152
1192,1192
1212,1212
1252,1252
1292,1292
1332,1332
1352,1352
1392,1392
1632,1632
1652,1652
1532,1532
1772,1772
1692,1692
1932,1932
1572,1572
1732,1732

];

Section Access;
Load * Inline [
USERID,ACCESS,ORGANIZATION_ID
"INTERNAL\SA_SCHEDULER",ADMIN,*
"user_ax",ADMIN,*
"user_a",USER,*
"user_b",USER,248
"user_c",USER,267
"user_c",USER,266
"user_c",USER,202
"user_c",USER,992
"user_d",USER,201
"user_e",USER,201
"user_f",USER,249
"user_g",USER,249
"user_h",USER,249
"user_i",USER,202
"user_j",USER,*
"user_k",USER,*
"user_l",USER,*
"user_m",USER,*
"user_n",USER,*
"user_o",USER,245
"user_o",USER,246
"user_o",USER,1432
"user_p",USER,1132
"user_q",USER,1152
"user_r",USER,1152
"user_s",USER,245
"user_s",USER,246
"user_s",USER,1432
"user_t",USER,1332
"user_t",USER,832
"user_t",USER,939
"user_t",USER,937
"user_t",USER,932
"user_t",USER,953
"user_t",USER,1212
"user_t",USER,935
"user_t",USER,834
"user_u",USER,1432
"user_v",USER,245
"user_v",USER,246
"user_v",USER,1432
"user_w",USER,245
"user_x",USER,246
"user_x",USER,245
"user_x",USER,1432
"user_y",USER,1332
"user_y",USER,832
"user_y",USER,939
"user_y",USER,937
"user_y",USER,932
"user_y",USER,953
"user_y",USER,1212
"user_y",USER,935
"user_z",USER,202
"user_z",USER,992
"user_aa",USER,201
"user_aa",USER,248
"user_aa",USER,267
"user_aa",USER,249
"user_aa",USER,201
"user_aa",USER,250
"user_aa",USER,207
"user_ab",USER,1332
"user_ac",USER,1332
"user_ac",USER,834
"user_ac",USER,932
"user_ac",USER,832
"user_ad",USER,248
"user_ae",USER,248
"user_af",USER,1192
"user_af",USER,209
"user_ag",USER,1392
"user_af",USER,204
"user_af",USER,855
"user_af",USER,206
"user_ah",USER,201
"user_ai",USER,201
"user_aj",USER,201
"user_ak",USER,201
"user_al",USER,201
"user_am",USER,248
"user_an",USER,248
"user_ao",USER,204
"user_ap",USER,204
"user_aq",USER,855
"user_aq",USER,206
"user_aq",USER,204
"user_ar",USER,206
"user_ar",USER,1192
"user_as",USER,202
"user_at",USER,202
"user_au",USER,202
"user_av",USER,202
"user_aw",USER,872
"user_ax",USER,248
"user_ay",USER,248
"user_az",USER,245
"user_ba",USER,1532
"user_ba",USER,852
"user_ba",USER,1132
"user_ba",USER,1152
"user_ba",USER,752
"user_ba",USER,853
"user_ba",USER,1252
"user_ba",USER,205
"user_ba",USER,363
"user_bb",USER,832
"user_bc",USER,1332
"user_bd",USER,245
"user_be",USER,266
"user_bf",USER,266
"user_bg",USER,267
"user_bh",USER,267
"user_bi",USER,853
"user_bj",USER,363
"user_bk",USER,363
"user_bl",USER,205
"user_bm",USER,852
"user_bn",USER,852
"user_bo",USER,852
"user_bp",USER,852
"user_bq",USER,205
"user_br",USER,205
"user_bs",USER,205
"user_bt",USER,1152
"user_bt",USER,1152
"user_bu",USER,1152
"user_bv",USER,752
"user_bw",USER,752
"user_bx",USER,752
"user_by",USER,752
"user_bz",USER,1252
"user_ca",USER,1252
"user_cb",USER,1132
"user_cc",USER,1132
"user_cd",USER,1252
"user_ce",USER,363
"user_cf",USER,363
"user_cg",USER,363
"user_ch",USER,363
"user_ci",USER,363
"user_cj",USER,853
"user_ck",USER,363
"user_cl",USER,1152
"user_cl",USER,363
"user_cl",USER,264
"user_cl",USER,1152
"user_cl",USER,205
"user_cl",USER,1132
"user_cl",USER,752
"user_cl",USER,853
"user_cl",USER,852

];
Section Application;

[Sierd_Boersma]

When using * with section access. Does not mean you will be accessing all the data. You will be able to access only the values that are meantioned in the table and not in your datamodel.

[tresB]

Try to keep one load for entire section access data or at least place them all together to avoid any confusion and unexpected result. I can see that you have two sections for access and the fields are not identical. I never tested this, still wouldn't expect to behave as expected. 

[marksouzacosta]

Hi @ireshaimali890 ,

@Sierd_Boersma is right. Using * means you are considering only the loaded values in your Section Access loaded table, not all possible values. Instead, leave it blank BUT, that affects only the ADMIN users.

Section Access;
Load * Inline [
USERID,ACCESS,ORGANIZATION_ID
"INTERNAL\SA_SCHEDULER",ADMIN, 
"user_ax",ADMIN, 
"user_a",USER,*
"user_b",USER,248
"user_c",USER,267
"user_c",USER,266
];

To give access to all values to USER users, you must list values, at least once - you can achieve that joining your user table with organization table.

Regards,

Mark Costa