Where is the user's group membership stored? I would like to know which users are in which user groups.

Version 1

    Details

    Where is the user's group membership stored? I would like to know which users are in which user groups.



    Resolution

    - In which user group(s) a user is added is stored in the USECURITY field in the USERS table for the specific user name row. This is an encrypted value and GoldMine Technical Support cannot provide any information on decryption of this value.


    - The list of user groups is stored in the LOOKUP table

    Select * from LOOKUP where FIELDNAME = 'MSPUSERGRPV'

    Results for user group names may look similar as screenshot below:



    Any reference within GoldMine e.g. in the field CONTACT1->OWNER is referenced by the LOOKUPSUPP+ENTRY value, means e.g. OWNER=1group1