Grouper Users - Open Discussion List

[Ellen Sluss <>]

Hi,

I am trying to create a set of groups through the grouperloader that 
have a particular group as the viewer and reader.

So I am using the grouperLoaderType SQL_GROUP_LIST.

My groups get created just fine but  the grouper loader won't 
automatically set the viewers and readers the way I think the 
documentation said it should. My sql looks like this:

select distinct(ucid) as SUBJECT_ID,
'uc:Reference:studentinfo:universitystartquarter:' + 
s.universitystartqtr as GROUP_NAME,
'uc:applications:myuchicago:admins' as readers,
'uc:applications:myuchicago:admins' as viewers
from currentstudent s,currentaccount a, individual i
where s.individualid=i.id and a.individualid=i.id and isnull(i.ucid,'') 
<> '' and isnull(s.universitystartqtr,'') <> '' and s.universitystartqtr 
> '200901'

When I check the read or view privileges on the groups after they have 
been created they all show the system wide default of GrouperAll and 
nothing else.

By system default we give Everyone read and view privilege when a group 
is created. I was hoping when a group for read and view was specified in 
the SQL that it would override the system wide default.


Thanks for any advice.




--
--

Ellen Sluss
IDM
IT Services

4-8179