Which table stores the role version details?

[yogesh2]

Which table stores these versions of the roles?

[rushikeshvartak · Accepted solution]

select ROLES_HISTORYCHANGELOGKEY,COMMENTS as 'Comment',CREATIONDATE,FIELDNAME,NEWVALUE NV ,OLDVALUE OV,OPERATION,ROLEHISTORYKEY,ROLEKEY,UPDATEUSER from roles_historychangelog;

[yogesh2]

I'm not able to do a "select *" on this table in Data Analyzer or Analytics

Can you please provide any column names?

[This message has been edited by moderator to mask sensitive info]

[rushikeshvartak]

Check updated query