topic Re: Updating section access with partial reload does not overwrite old section access settings in Management & Governance

Updating section access with partial reload does not overwrite old section access settings

dirk_fischer — Wed, 29 Jan 2025 16:21:29 GMT

Dear all,

we try to update our section access, when doing a partial reload. Attached is the code of the sample application, we use. If we run the code as full reload, everything works as expected. The user FISCHERD has access to the number 3 only.

If we run the same script as partial reload, the user FISCHERD has access to the numbers 3 AND 5 instead of 5 only.

Does anybody have an idea, where this is coming from and how to overcome this problem?

Thank you very much for your support.

Best regards

Dirk

ZAHLEN:

Replace Load * inline [ ZAHL, WORT, REDUCTION

1, EINS, 1

2, ZWEI, 2

3, DREI, 3

4, VIER, 4

5, FUENF,5

6, SECHS, 6

7, SIEBEN, 7

8, ACHT, 8

9, NEUN,9

10, ZEHN,10

11, ELF,11

12, ZWOELF,12

13, DREIZEHN,13

14, VIERZEHN,14

15, FUENFZEHN,15

16, SECHSZEHN,16

17, SIEBZEHN, 17

];

Call createBaseUserTable;

call DropTable('TEMP_ACCESS_TABLE');

Rename Table 'BASE_USER_TABLE' to 'TEMP_ACCESS_TABLE';

Exit Script;

Left Join(TEMP_ACCESS_TABLE)*/

If IsPartialReload() Then

TEMP_ACCESS_TABLE:

Replace NoConcatenate Load * Inline [ACCESS, USERID ,REDUCTION

USER, ACCOUNTS\FISCHERD, 5

ADMIN, ACCOUNTS\SCHMIDRU,3

ADMIN, ACCOUNTS\SCHMIDRU,5

ADMIN, INTERNAL\SA_SCHEDULER,

ADMIN, INTERNAL\SA_API,

];

Else

TEMP_ACCESS_TABLE:

Replace Load * Inline [ACCESS, USERID ,REDUCTION

USER, ACCOUNTS\FISCHERD, 3

ADMIN, ACCOUNTS\SCHMIDRU,3

ADMIN, ACCOUNTS\SCHMIDRU,5

ADMIN, INTERNAL\SA_SCHEDULER,

ADMIN, INTERNAL\SA_REPOSITORY,

ADMIN, INTERNAL\SA_API,

];

End If

Section Access;

ACCESS_TABLE:

NoConcatenate

REPLACE LOAD * Resident TEMP_ACCESS_TABLE;

Section Application;

DropTable TEMP_ACCESS_TABLE;

Re: Updating section access with partial reload does not overwrite old section access settings

TauseefKhan — Fri, 24 May 2024 11:16:00 GMT

Hi @dirk_fischer,

I think partial reload is not fully replacing the section access table with the new data. Explicitly replace the section access table during a partial reload to ensure that the new data completely overwrites the existing section access table.

Check with this steps:

//1- Your Data source.

//2- Clear the existing section access table
Section Access;
LOAD * INLINE [
ACCESS, USERID, REDUCTION
];

//3- Partial Reload
If IsPartialReload() Then

//4- Replace the section access table with the new data

Section Access;
LOAD * INLINE [
ACCESS, USERID, REDUCTION
USER, ACCOUNTS\FISCHERD, 5
ADMIN, ACCOUNTS\SCHMIDRU, 3
ADMIN, ACCOUNTS\SCHMIDRU, 5
ADMIN, INTERNAL\SA_SCHEDULER,
ADMIN, INTERNAL\SA_API
];
Else
// Full Reload
Section Access;
LOAD * INLINE [
ACCESS, USERID, REDUCTION
USER, ACCOUNTS\FISCHERD, 3
ADMIN, ACCOUNTS\SCHMIDRU, 3
ADMIN, ACCOUNTS\SCHMIDRU, 5
ADMIN, INTERNAL\SA_SCHEDULER,
ADMIN, INTERNAL\SA_REPOSITORY,
ADMIN, INTERNAL\SA_API
];
End If;

Section Application;

******** Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.********

Re: Updating section access with partial reload does not overwrite old section access settings

dirk_fischer — Fri, 24 May 2024 11:37:47 GMT

Hi @TauseefKhan

great, this did the trick.

Thank you very much for your help.

Best regards,

Dirk

Re: Updating section access with partial reload does not overwrite old section access settings

dyy — Thu, 16 Apr 2026 16:36:29 GMT

I am trying to implement this for a partial reload for Section Access but, as soon as user presses the button to trigger the partial reload, all selections are CLEARED . I believe it is because the user is no longer in that section access table for a brief moment as it cleared and replaced with the partial reload access table. The selections need to be maintained after the partial reload for this process to work. How can I ensure it does not clear the selections (NO , locking them does not work because that user does not have access to that data at that moment so it will clear selections for values that do not exist for that user. Only the one island table selection is maintained as it is not part of the SA data model.

Re: Updating section access with partial reload does not overwrite old section access settings

dirk_fischer — Thu, 16 Apr 2026 16:54:49 GMT

Hi dyy

this is what I use. I have this sub for activating the section access and call it pretty much at the end of the script. Of course, you need to adapt your own access table and make sure the user has access to the data after section access activation. But for me this works without resetting selections.

Best regards,

Dirk

Sub ActivateSectionAccess
vStartOfSub = Now();
Let vTraceMsg = 'Start of sub activateSectionAccess at ' & Timestamp('$(vStartOfSub)', 'YYYY-MM-DD hh:mm:ss');
Trace '$(vTraceMsg)';

Call DropTable('ACCESS_TABLE');

Section Access;
Let vTraceMsg = 'Resetting the section access';
Trace '$(vTraceMsg)';
Replace Load
*
Inline [ACCESS, USERID, REDUCTION
]
;
Section Application;

Call TraceBeforeTableOp('Adding the default users to table ACCESS_TABLE', 'ACCESS_TABLE');
ACCESS_TABLE:
Add Load
ACCESS
,USERID
,REDUCTION
Inline [ACCESS, USERID, REDUCTION
ADMIN, INTERNAL\SA_REPOSITORY,
ADMIN, INTERNAL\SA_SCHEDULER,
ADMIN, INTERNAL\SA_API,

Re: Updating section access with partial reload does not overwrite old section access settings

dyy — Thu, 16 Apr 2026 18:32:22 GMT

Thank you got the quick response but I’m not understanding this solution. I need this in a partial reload and this code does not look complete . No end sub and calling other subs not defined here . What am I missing ?

not sure what it is doing