I am building a simple calculation view of the user history table (AUSR) and want to add the authorizations groups belonging to that user in a single fields, so that it will be just one line per user.
I read up on the cursor, but not sure where or how to use it.. also thought of using the STRING_AGG, also..not sure if that will work.
Ideally, I'd like to create this field in my current calculation view. Please can I get advise and pointers on this.
Thank you all :)