cancel
Showing results for 
Search instead for 
Did you mean: 

Number limitation of mxref_mx_privileges

clotilde_martinez
Participant
0 Kudos

Hi experts,

we are running idm 7.2 sp8 on oracle.

Do any of you ever reached a limit on the number of mxref_mx_privileges to assign to a user? If so, of how many was it?

We calculated that using nvarchar2 with 4000 bytes we would manage to have between 550 et 600 privileges per user, is it a good calculation?

To explain a little further, my actual project will connect something like 80 systems and we'll give SAP roles through reference users.

Those reference users are linked to almost every system and have around 100 or more privileges by system (so we'll have reference users with around 800 or more privileges) so if there is a limit i need to know it in advance so as to offer a workaround for it.

Thanks a lot,

Clotilde

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Every assigned privilege is just a row in the table MXI_LINK (and assorted views) so there is no implied limit from a database point of view....

Former Member
0 Kudos

Correct, and in 7.2 the DSE runtime will split each assignment in passes (mxref_mx_privilege=<privA>|<privB>|<privC>....) into separate operations so you're not even limited to nvarchar(4000) assignments in a single pass either. You might see some challenges in the form of the length of the transaction when writing thousands of attributes in a single pass though.

Best regards,
Per Christian Krabsetsve

Answers (2)

Answers (2)

0 Kudos

Although there may not be physical limitations be aware that displaying or modifying the assigned privileges via the MX_ASSIGNMENTS or MXREF_MX_PRIVILEGE-Attribute in the UI may become an (performance) issue (but this also depends on other factors like visibility settings for the privileges).

But no limitations from the backend point of view.

Tobias

ChrisPS
Contributor
0 Kudos

Hi - also don't forget limitation on ABAP servers of 312 profiles per user.

Cheers,

Chris