Getting a list of users/groups in project security

[Peter Tillemans]

Hi,

I have a number of ppl working on a shared model with security enabled. I'd like to get a list from the application with the users and the groups they are assigned to.

I have been looking in the security section, project settings, documentation output, but if it is there, I must have looked over it. The help also remains mute to me regarding this.

Is this possible? If it is not, has anyone a tip for a workaround?

thanks,

best regards,

Peter Tillemans

[Geert Bellekens]

Peter,

You can make an SQL search to return that data.

something like this should work:

Code: [Select]

select su.UserLogin, su.FirstName, su.Surname, sg.GroupName, sg.Description from ((t_secuser su
inner join t_secusergroup sug on su.UserID = sug.UserID)
inner join t_secgroup sg on sg.GroupID = sug.GroupID)
Geert

[Peter Tillemans]

Geert,

awesome, thanks, I owe you one.

best regards,

Peter Tillemans