[Building Sakai] Creating (and then propagating) new roles in Sakai...?

[will at serensoft.com]

Some questions about realms and creating new roles:

We've started with the default three roles for courses, plus lots of
course worksites all ready to go. Now, of course, after the fact, we
want to add some new roles to all these courses... :)

Is there some SQL somewhere within confluence that might handle this?
Googling has turned up some webservices by Steve S, which look like
they might be useful, but we're hoping for some SQL to make short work
of this.

And is this the sequence?...
1) create course roles in realm !site.template.course with all
checkboxes set as appropriate
2) replicate/copy those roles to all the realms for course worksite
instances (including groups?)
Right?

One final question -- if the check-boxes are ON in the
!site.template.course realm, they don't need to also be on in the
individual courses as well, right? That is, the permissions are OR'ed,
meaning that, for your role X, if worksite-specific-realm checkmarks
are ON fo role X, *or* worksite-template-realm checkmarks are on for
role X, then those in role X have that permission.

That seems to be what Zach is saying here:
http://aeroplanesoftware.com/sakai-permissions-in-depth/

Right? :)

-- 
will trillich
"Tis the set of the sails / And not the gales / That tells the way we
go." -- Ella Wheeler Wilcox