To allow computation of statistics, the students need the ANALYZE ANY privilege.

GRANT ANALYZE ANY TO ismg6480student01,ismg6480student02, ismg6480student03,ismg6480student04,
ismg6480student05,ismg6480student06,ismg6480student07,ismg6480student08,ismg6480student09,
ismg6480student10,ismg6480student11,ismg6480student12,ismg6480student13,ismg6480student14,
ismg6480student15,ismg6480student16,ismg6480student17,ismg6480student18,ismg6480student19,
ismg6480student20,ismg6480student21,ismg6480student22,ismg6480student23,ismg6480student24,
ismg6480student25,ismg6480student26,ismg6480student27,ismg6480student28,ismg6480student29,
ismg6480student30;

GRANT ALTER SESSION TO ismg6480student01,ismg6480student02, ismg6480student03,ismg6480student04,
ismg6480student05,ismg6480student06,ismg6480student07,ismg6480student08,ismg6480student09,
ismg6480student10,ismg6480student11,ismg6480student12,ismg6480student13,ismg6480student14,
ismg6480student15,ismg6480student16,ismg6480student17,ismg6480student18,ismg6480student19,
ismg6480student20,ismg6480student21,ismg6480student22,ismg6480student23,ismg6480student24,
ismg6480student25,ismg6480student26,ismg6480student27,ismg6480student28,ismg6480student29,
ismg6480student30;

-- The SELECT ANY DICTIONARY permission is needed to query dictionary tables about
-- optimizer statistics.

GRANT SELECT ANY DICTIONARY TO ismg6480student01,ismg6480student02, ismg6480student03,ismg6480student04,
ismg6480student05,ismg6480student06,ismg6480student07,ismg6480student08,ismg6480student09,
ismg6480student10,ismg6480student11,ismg6480student12,ismg6480student13,ismg6480student14,
ismg6480student15,ismg6480student16,ismg6480student17,ismg6480student18,ismg6480student19,
ismg6480student20,ismg6480student21,ismg6480student22,ismg6480student23,ismg6480student24,
ismg6480student25,ismg6480student26,ismg6480student27,ismg6480student28,ismg6480student29,
ismg6480student30;

-- The DBA needs to create the PlusTrace role before it can be granted.
-- The PlusTrace role is needed for the students to use AUTOTRACE.
CREATE ROLE PlusTrace;

GRANT PLUSTRACE TO ismg6480student01,ismg6480student02, ismg6480student03,ismg6480student04,
ismg6480student05,ismg6480student06,ismg6480student07,ismg6480student08,ismg6480student09,
ismg6480student10,ismg6480student11,ismg6480student12,ismg6480student13,ismg6480student14,
ismg6480student15,ismg6480student16,ismg6480student17,ismg6480student18,ismg6480student19,
ismg6480student20,ismg6480student21,ismg6480student22,ismg6480student23,ismg6480student24,
ismg6480student25,ismg6480student26,ismg6480student27,ismg6480student28,ismg6480student29,
ismg6480student30;