Grouper Users - Open Discussion List

[Carl Waldbieser <>]

Bert & Chris,

Thanks, that was just what I needed.
We have a target system that requires some additional information that is 
mapped to *policies* rather than subjects, and I thought this would probably 
be the best way to configure and convey that information.

Thanks,
Carl Waldbieser
ITS Identity Management
Lafayette College

----- Original Message -----
From: "Chris Hyzer" 
<>
To: "Carl Waldbieser" 
<>,
 "grouper-users" 
<>
Sent: Thursday, 20 September, 2018 13:04:11
Subject: RE: Group custom attributes via GSH and SQL views

gsh 0% GrouperSession grouperSession = GrouperSession.startRootSession();
gsh 1% AttributeDef attributeDef = new 
AttributeDefSave(grouperSession).assignName("test:testAttribute:someAttrDef").assignCreateParentStemsIfNotExist(true).assignToGroup(true).assignAttributeDefType(AttributeDefType.attr).assignMultiAssignable(false).assignMultiValued(false).assignValueType(AttributeDefValueType.string).save();
gsh 2% AttributeDefName attributeDefName = new 
AttributeDefNameSave(grouperSession, 
attributeDef).assignName("test:testAttribute:someAttr").assignCreateParentStemsIfNotExist(true).save();
gsh 3% Group group = new 
GroupSave(grouperSession).assignName("test:testAttribute:group").assignCreateParentStemsIfNotExist(true).save()
gsh 4% 
group.getAttributeValueDelegate().assignValueString(attributeDefName.getName(),
 "someValue");
edu.internet2.middleware.grouper.attr.value.AttributeValueResult: 
edu.internet2.middleware.grouper.attr.value.AttributeValueResult@2f08e6d3
gsh 5%

SELECT value_string FROM grouper_aval_asn_group_v WHERE group_name = 
'test:testAttribute:group' AND attribute_def_name_name = 
'test:testAttribute:someAttr'

returns someValue

-----Original Message-----
From: 

 
<>
 On Behalf Of Carl Waldbieser
Sent: Thursday, September 20, 2018 12:26 PM
To: grouper-users 
<>
Subject: [grouper-users] Group custom attributes via GSH and SQL views


I'd like to create a custom attribute that would be used on several groups.  
I'd like the attribute to be able to hold one of several distinct enumerated 
values, though I suppose I could use a plain text value.  I'd like to be able 
to set the attribute and value on particular groups via a GSH script, and I'd 
like to be able to read the attribute via SQL using the Grouper view tables.

Any pointers on how to configure something like this?  GSH examples for 
setting an attribute and value on a group?  And what SQL views hold the 
group-attribute-value?

Thanks,
Carl Waldbieser
ITS Identity Management
Lafayette College