Log in Register FAQ Memberlist Search ContactReview Forum Index
A GoldMine Discussion and Support Community

ContactReview Forum Index » GoldMine 8 / 9 / 2013 / 2014 / 2015 (Premium Edition) » User Group Definition Table for GMPE 2018.1.2
Post new topic  Reply to topic View previous topic :: View next topic 
User Group Definition Table for GMPE 2018.1.2
PostPosted: Fri Nov 30, 2018 8:57 am Points: 0 Reply with quote
cdohmen
Cuckoo for GoldMine Puffs
Joined: 06 Mar 2009
Posts: 255
Location: Pittsburgh, PA




Anyone know the table location of the user group definitions.

Thanks in advance
View user's profile Send private message

PostPosted: Sat Dec 01, 2018 3:26 pm Points: 0 Reply with quote
Paul Laufer
GoldBox Guru
Joined: 27 Oct 2008
Posts: 124




The user group names are in LOOKUP.

select * from lookup
where fieldname like 'MSPUSERGRP%'

Group memberships are stored in the user's encrypted security fields (where the passwords are stored), and aren't available via just looking at the data with a SQL query.

_________________
Paul Laufer
Telesage Solutions
www.tsage.com
View user's profile Send private message Visit poster's website

User Group Definition Table for GMPE 2018.1.2
  ContactReview Forum Index » GoldMine 8 / 9 / 2013 / 2014 / 2015 (Premium Edition)
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
All times are GMT - 7 Hours  
Page 1 of 1  

  
  
 Post new topic  Reply to topic  


Brought to you by Castell Computers, Doug Castell, Admin
RSS Feed
Powered by phpBB © 2001-2004 phpBB Group
Theme created by Vjacheslav Trushkin