How to Add a hostedadmin account as a Responsible User to a single Data Validation Group

1. Identify GID of Data Validation Group

• The GID is found in the DVG table
  Example:
  

  SELECT * FROM DVG 

  

2. Identify UID of User

• The UID is found in the UGN table
  Example:
  

  SELECT * FROM UGN WHERE UN = 'AERIES.HANNAHR'

  

3. Insert the DVU record(s)

• Using the desired Group ID from DVG and the User ID from UGN, insert the DVU record
  Example:

  INSERT DVU (GID, UID) 
  VALUES (1, 123489)