##Lists Available Course tools for all courses with an id containing MATH (not all allow guest access)##
select distinct(label), Application from bb_bb60.course_application where crsmain_pk1 IN ( select pk1 from bb_bb60.course_main where COURSE_ID like '%MATH%')


##This allows guest access to the CONTENT AREA tool for all courses with an id containing MATH##
update bb_bb60.course_application set ALLOW_GUEST_IND ='Y'
where crsmain_pk1 IN (
select pk1 from bb_bb60.course_main where COURSE_ID like '%MATH%') and label = 'content.label'


##This allows guest access to the STAFF INFORMATION tool for all courses with an id containing MATH##
update bb_bb60.course_application set ALLOW_GUEST_IND ='Y'
where crsmain_pk1 IN (
select pk1 from bb_bb60.course_main where COURSE_ID like '%MATH%') and label = 'staff_information.label'


##Lists Available Menu Items for all courses with an id containing MATH##
select distinct(label) from bb_bb60.course_toc
where crsmain_pk1 in (
select pk1 from bb_bb60.course_main
where course_id like '%MATH%')


##This allows guest access to the Session and resources menu item for all courses with an id containing MATH##
update bb_bb60.course_toc set allow_guest_ind = 'Y'
where crsmain_pk1 in (
select pk1 from bb_bb60.course_main
where course_id like '%MATH%')
and label = 'Sessions/Resources'


##This allows guest access to the Module Information menu item for all courses with an id containing MATH##
update bb_bb60.course_toc set allow_guest_ind = 'Y'
where crsmain_pk1 in (
select pk1 from bb_bb60.course_main
where course_id like '%MATH%')
and label = 'Module Information'


##This allows guest access to the Staff Information menu item for all courses with an id containing MATH##
update bb_bb60.course_toc set allow_guest_ind = 'Y'
where crsmain_pk1 in (
select pk1 from bb_bb60.course_main
where course_id like '%MATH%')
and label = 'COURSE_DEFAULT.StaffInformation.STAFF.label'