XSA: Looking for a table of all "Role Collections"

[draschke]

Could somebody help to find out in which table I can find all the "Role Collections" created for the business user?

Thanks!

[thomas_jung]

Well I think the info you want is in SYS_XS_UAA.XS_ROLECOLLETION2USER. However this schema is owned by SYS_XS_UAA and even SYSTEM doesn't have read access. I don't see any role that would grant access. It looks as those these tables and views in the UAA schemas are for internal access only.

[draschke]

Hi Thomas,

thanks for this hint. You are right, even the system user has not the privileges.

That's a pity, because we need them for our IdM Project. So that the key user is able to select between the different collections. (Not inside of the XSA Cockpit. Its an own UI)

Of course we can get the already assigned roles from the users parameters, but its ugly.

Thanks!

[thomas_jung]

Actually you could get this information via the UAA API. I've written a little example here:

https://github.com/I809764/controllerAPI/blob/master/node/router/routes/users.js

I used two of the many UAA APIs in this sample. I get the Role Collections assigned to the user:

As well as all possible Role Collections:

[draschke]

Thank you for your answer and thank you for your nice blog "XSA Controller Interaction" which explains everything in detail. It's very helpful!