Role Audit

Tagged: 

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #4042
    ms
    Keymaster

    Is there a way to see which users have what roles and when they were assigned them?

    In particular I need to see when a user was given a role.

    Thanks so much.

    • This topic was modified 3 years, 2 months ago by ms.
    #4044
    Stefan Reichelt
    Participant

    I have to say that I like your questions. They keep me thinking out of my box. Please give me more! 😉

    But to answer this one:

    Part 1: Unfortunately, I think there is absolutely no way to see when it was assigned. We can track the last modified date for many things, but not for the affected link table User_Pob_Role.
    I already played with a History trigger based on a CollectionChanged Condition, but the PQL [AddedItem.Id] (nor [AddedItem.Description]) didn’t work there. If you require it, you should ask Wendia Support. IMHO, it is even a bug that [AddedItem.<column>] doesn’t work if you use it for an EM based table like PobRole. Do you know how to contact them and what to write? I would be interested in their answer as well.

    Part 2:
    Regarding the “who and which one”, please have a look back at my SQL statements on the other thread. Did you find someone to help you with the DB query?
    If you need a more comfortable way within the GUI, you may need to open an RFC to Wendia.

Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.