Grant SELECT ON inventory_fact TO PUBLIC;

Grant SELECT ON date_dim TO PUBLIC;

Grant SELECT ON trans_type_dim TO PUBLIC;

Grant SELECT ON cust_vendor_dim TO PUBLIC;

Grant SELECT ON item_master_dim TO PUBLIC;

Grant SELECT ON branch_plant_dim TO PUBLIC;

Grant SELECT ON company_dim TO PUBLIC;

Grant SELECT ON addr_cat_code1 TO PUBLIC;

Grant SELECT ON addr_cat_code2 TO PUBLIC;

Grant SELECT ON item_cat_code1 TO PUBLIC;

Grant SELECT ON item_cat_code2 TO PUBLIC;

Grant SELECT ON zip_codes TO PUBLIC;

-- To create dimensions and MVs using my tables, students need SELECT ANY TABLE permission.
-- I am not sure why granting select access to public is not sufficient but
-- SELECT ANY TABLE permission is needed.

GRANT SELECT ANY TABLE 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;


commit;

To create dimensions, users need the CREATE DIMENSION privilege. DBA users have this privilege. 
Normal users with the CONNECT and RESOURCE roles do not have this privilege. 

GRANT CREATE DIMENSION 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 CREATE DIMENSION 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;

commit;

GRANT CREATE DIMENSION TO scott;

To create materialized views, users need the CREATE MATERIALIZED VIEW privilege. DBA users 
have this privilege. Normal users with the CONNECT and RESOURCE roles do not have this privilege. 
For example, the following statement grants the permission to the default user “scott”.

GRANT CREATE MATERIALIZED VIEW TO scott;

GRANT CREATE MATERIALIZED VIEW 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 CREATE MATERIALIZED VIEW 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;

commit;