Skip to Content

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

Apr 17 at 09:33 AM


avatar image

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


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Thomas Jung
Apr 18 at 04:02 PM

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.

Show 3 Share
10 |10000 characters needed characters left characters exceeded

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.



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

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:

uaa1.png (103.5 kB)
uaa2.png (120.4 kB)

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