b_gilmore
Well Known Member
Re: [Re: [Inclusive Row Security]]
The first thing I did was locate a list of tables which contained the MCU
field. The F98711 has that info.
I took that list and wrote sql to return the distinct values of the MCU field
for each table. Any table that only returned BU values and nothing else went
on the list to be added to row security. Any table returning values other
than BU's (e.g. Work Centers) was excluded from the list. Any tables
returning 0 records were also excluded.
Using that list, I then used a SQL join statement to insert the records into
the F00950 for the requisite groups and BU's. Beats keying it in.
Here the list of tables I came up with. The list will vary depending on the
modules you're using. After I put this in, the only issue we encountered was
with Supply and Demand. This app uses a Work File (F4021W) that originally
showed up in the list and was causing the items to not appear in the grid when
the users clicked Find. I took this one out and all was well.
F0411Z3
F0411Z3
F0414Z1
F0414Z1
F3111
F3111
F3209
F3209
F3281
F3281
F3282
F3282
F32821
F32821
F3283
F3283
F3291
F3291
F3292
F3292
F32921
F32921
F32922
F32922
F3293
F3293
F32943
F32943
F3295
F3295
F3296
F3296
F32961
F32961
F3411
F3411
F3412
F3412
F3413
F3413
F3430
F3430
F3460
F3460
F3462
F3462
F40095
F40095
F4021W
F4021W
F40309
F40309
F40315
F40315
F41UI003
F41UI003
F4100
F4100
F4100T
F4100T
F4101A
F4101A
F4101C
F4101C
F4101G
F4101G
F4101M
F4101M
F4101P
F4101P
F4101T
F4101T
F41015
F41015
F4102
F4102
F41021
F41021
F4105
F4105
F4106
F4106
F41061
F41061
F4108
F4108
F4111
F4111
F41112
F41112
F4115
F4115
F4141
F4141
F4160
F4160
F42005
F42005
F42008
F42008
F4201
F4201
F4201Z1
F4201Z1
F4209
F4209
F4211
F4211
F4211Z1
F4211Z1
F42119
F42119
F42199
F42199
F4229
F4229
F42565
F42565
F4301
F4301
F4301Z1
F4301Z1
F43090
F43090
F43091
F43091
F43092
F43092
F4311
F4311
F4311Z1
F4311Z1
F43121
F43121
F43199
F43199
F4801
F4801
F4801Z1
F4801Z1
eanderson <[email protected]> wrote:
you were not able to use *ALL/MCU Row Security?We are looking to implement Row
Security to restrict access to different Branch Plants...We will be using
Inclusive Row Security.Any advice would be much appreciated.Thanks,Eric
The first thing I did was locate a list of tables which contained the MCU
field. The F98711 has that info.
I took that list and wrote sql to return the distinct values of the MCU field
for each table. Any table that only returned BU values and nothing else went
on the list to be added to row security. Any table returning values other
than BU's (e.g. Work Centers) was excluded from the list. Any tables
returning 0 records were also excluded.
Using that list, I then used a SQL join statement to insert the records into
the F00950 for the requisite groups and BU's. Beats keying it in.
Here the list of tables I came up with. The list will vary depending on the
modules you're using. After I put this in, the only issue we encountered was
with Supply and Demand. This app uses a Work File (F4021W) that originally
showed up in the list and was causing the items to not appear in the grid when
the users clicked Find. I took this one out and all was well.
F0411Z3
F0411Z3
F0414Z1
F0414Z1
F3111
F3111
F3209
F3209
F3281
F3281
F3282
F3282
F32821
F32821
F3283
F3283
F3291
F3291
F3292
F3292
F32921
F32921
F32922
F32922
F3293
F3293
F32943
F32943
F3295
F3295
F3296
F3296
F32961
F32961
F3411
F3411
F3412
F3412
F3413
F3413
F3430
F3430
F3460
F3460
F3462
F3462
F40095
F40095
F4021W
F4021W
F40309
F40309
F40315
F40315
F41UI003
F41UI003
F4100
F4100
F4100T
F4100T
F4101A
F4101A
F4101C
F4101C
F4101G
F4101G
F4101M
F4101M
F4101P
F4101P
F4101T
F4101T
F41015
F41015
F4102
F4102
F41021
F41021
F4105
F4105
F4106
F4106
F41061
F41061
F4108
F4108
F4111
F4111
F41112
F41112
F4115
F4115
F4141
F4141
F4160
F4160
F42005
F42005
F42008
F42008
F4201
F4201
F4201Z1
F4201Z1
F4209
F4209
F4211
F4211
F4211Z1
F4211Z1
F42119
F42119
F42199
F42199
F4229
F4229
F42565
F42565
F4301
F4301
F4301Z1
F4301Z1
F43090
F43090
F43091
F43091
F43092
F43092
F4311
F4311
F4311Z1
F4311Z1
F43121
F43121
F43199
F43199
F4801
F4801
F4801Z1
F4801Z1
eanderson <[email protected]> wrote:
you were not able to use *ALL/MCU Row Security?We are looking to implement Row
Security to restrict access to different Branch Plants...We will be using
Inclusive Row Security.Any advice would be much appreciated.Thanks,Eric