[Building Sakai] Sakai CM - Official Instructors

[Jaco Gillman]

Hi All



I am investigating a Sakai bug with one of our Lecturers. The Lecturer is
only Official Instructor for 2 different modules, but when this user tries
to create a new Course Site possible modules shows up for creation even
though there is no Official Instructor mapping in the Database for
the Enrollment set.



This is the view the Lecturers sees on our instance:




[image: Inline images 7]

[image: Inline images 8]

[image: Inline images 9]


Then I ran the following SQL query to see which Enrolment Sets the user is
an Official Instructor of:



*SELECT * FROM CM_OFFICIAL_INSTRUCTORS_T OI WHERE OI.INSTRUCTOR_ID =
'21974640';*



*Result Set:*

*ENROLLMENT_SET_ID  INSTRUCTOR_ID*

*5583                                        21974640*

*5845                                        21974640*



Then I query the Enrolment Set table to get all Enrolment Sets for the
Lecturer with the following query:



*SELECT CES.ENROLLMENT_SET_ID,*

*CES.CREATED_DATE,*

*CES.ENTERPRISE_ID,*

*CES.TITLE,*

*CES.DESCRIPTION*

*FROM CM_ENROLLMENT_SET_T CES WHERE*

*CES.ENROLLMENT_SET_ID IN (SELECT OI.ENROLLMENT_SET_ID FROM
CM_OFFICIAL_INSTRUCTORS_T OI WHERE OI.INSTRUCTOR_ID = '21974640');*



*Result Set:*

*ENROLLMENT_SET_ID  CREATED_DATE  ENTERPRISE_ID   TITLE
DESCRIPTION*

*5583    2013-01-03      ACCC 111 M 2013 ES         ACCC 111 M 2013
ES         ACCC 111 M 2013 ES*

*5845    2013-01-21      ACCF 111 M 2013 ES          ACCF 111 M 2013
ES          ACCF 111 M 2013 ES*



>From this Result Set, I can see that the Instructor "*21974640*" is an
Official Instructor for ACCC 111 M 2013 ES and *ACCC 111 M 2013 ES. *They
are the ones I encircled in the images above. From my knowledge and
understanding of Sakai Course Management, a Lecturer that wants to create a
Course Site, will only be able to see Enrollments for selection those of
which he/she is an Official Instructor of. Any idea why this specific
Lecturer sees other Enrollments Sets? Am I looking in the wrong place?

Regards,

*Jaco Gillman***

Java Developer

opencollab

*Tel*: +27 21 970 4017  |  *Fax*:* *+27 21 914 3098**

*Email*: jaco at opencollab.co.za  |  *Skype*: gillmanjc

*Web*: www.opencollab.co.za
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130214/bb757388/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 88200 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130214/bb757388/attachment.png 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 75711 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130214/bb757388/attachment-0001.png 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 66506 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130214/bb757388/attachment-0002.png