[Building Sakai] Forums (msgcntr) default permissions

[Wagner, Michelle R.]

Hi Jeremy,
OOTB, the Contributor level has both the Edit and Delete Own set to None, so it does sound like your institution must have modified the default at some point.

First you need to track down the TYPE_UUID for the Contributor permission level in CMN_TYPE_T.  Something like:

SELECT TYPE_UUID FROM CMN_TYPE_T WHERE KEYWORD = 'Contributor Permission Level'

Then use this TYPE_UUID to find what your default settings are in MFR_PERMISSION_LEVEL_T:
SELECT * from MFR_PERMISSION_LEVEL_T where TYPE_UUID='xxxx'

If this record doesn't exist in the MFR_PERMISSION_LEVEL_T table, the code will use a default set of permissions for the Contributor level.  If this record is missing, there should be a warning on tomcat startup that says something like:
"No permission level data exists for the Contributor level in the MFR_PERMISSION_LEVEL_T table. Default Contributor permissions will be used. If you want to customize this permission level, use mfr.sql as a reference to add this level to the table."

Years ago at Indiana, one of these default records disappeared from our database and we were never able to figure out why.  Maybe you are experiencing the same issue?  Otherwise, the obvious question is have you updated the msgcntr code recently?  If the above isn't your issue, let us know what version of msgcntr you are running and if anything has changed recently.

Have a great day,
Michelle
________________________________
From: sakai-dev-bounces at collab.sakaiproject.org [sakai-dev-bounces at collab.sakaiproject.org] on behalf of Kusnetz, Jeremy [JKusnetz at APUS.EDU]
Sent: Tuesday, September 24, 2013 12:57 PM
To: Sakai Developers
Subject: [Building Sakai] Forums (msgcntr) default permissions

Sometime in the past week our permission level “Contributor” seems to have switched both the Edit and Delete Messages from Own to None, and now student’s can’t edit their own threads unless we fix the individual forum’s permissions.

This seems to be affecting all courses, even old ones a couple of years old.

Where is the default permission levels set?

I’ve checked the MFR_PERMISSION_LEVEL_T table, and only a small fraction of the NAME=”Contributor” is set to REVISE_OWN=0.

I’m having a hard time finding documentation on how to set the default values for the permission levels.

This message is private and confidential. If you have received it in error, please notify the sender and remove it from your system.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130925/fecf1502/attachment.html