- 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