PIS:Pouzivane stagove tabulky v Coursewaru

• Orion_ucitele
• Ucitele
• cg_ref_codes
• cis_pracovist
• rozvrh_akce
• pred_varianty
• uc_rozvrhove_akce

• kalendar
• dual :))

• vstudenti_na_programu_v_roce
• orion
• znamky
• ucitele_predmetu

12.1.2007 17:55

• cis_liter
• pred_liter
• pred_programy
• np_pod
• np_vyluc

29.01.2007

• terminy

9.2.2007

• osoby

17.5.2007

• obory

22.5.2007

• grupy_terminu
• nadgrupy_terminu
• studenti_na_zkouskach

7.6.2007

• funkce FN_GET_ROK_PRO_ZAPIS_ZKOUSEK
• parametry_stagu
• pred_programy
• np_pod
• np_vyluc
• pred_liter
• cis_liter

1.11.2007

• procedura PR_GET_SYLABUS

 -- 11.12.06 19:52
 CREATE USER cw_stag
 IDENTIFIED BY xxxxxxxxxxxxxx
 DEFAULT TABLESPACE USR_DATA
 TEMPORARY TABLESPACE TMP
 PROFILE DEFAULT
 ACCOUNT UNLOCK;
 ----------------------------------------------
 GRANT USER_COMMON TO cw_stag;
 GRANT CONNECT TO cw_stag;
 GRANT RESOURCE TO cw_stag;
 ALTER USER cw_stag DEFAULT ROLE ALL;
 GRANT UNLIMITED TABLESPACE TO cw_stag;
 ----------------------------------------------
 GRANT SELECT ON  INSTALL2.ORION_UCITELE TO cw_stag;
 GRANT SELECT ON  INSTALL2.UCITELE TO cw_stag;
 GRANT SELECT ON  INSTALL2.CG_REF_CODES TO cw_stag;
 GRANT SELECT ON  INSTALL2.CIS_PRACOVIST TO cw_stag;
 GRANT SELECT ON  INSTALL2.PRED_VARIANTY TO cw_stag;
 GRANT SELECT ON  INSTALL2.ROZVRH_AKCE TO cw_stag;
 GRANT SELECT ON  INSTALL2.UC_ROZVRHOVE_AKCE TO cw_stag;
 GRANT SELECT ON  INSTALL2.KALENDAR TO cw_stag;
 GRANT SELECT ON  INSTALL2.VSTUDENTI_NA_PROGRAMU_V_ROCE TO cw_stag;
 GRANT SELECT ON  INSTALL2.ORION TO cw_stag;
 GRANT SELECT ON  INSTALL2.ZNAMKY TO cw_stag;
 GRANT SELECT ON  INSTALL2.UCITELE_PREDMETU TO cw_stag;
 GRANT EXECUTE ON  INSTALL2.Fn_Meaning TO cw_stag;
 GRANT EXECUTE ON  INSTALL2.FN_MEANING2 TO cw_stag;
 GRANT EXECUTE ON  INSTALL2.FN_MEANING3 TO cw_stag;
-- 12.1.2007
 GRANT SELECT ON  PRED_PROGRAMY  TO CW_STAG;
 GRANT SELECT ON  PRED_LITER TO CW_STAG;
 GRANT SELECT ON  NP_POD  TO CW_STAG;
 GRANT SELECT ON  NP_VYLUC  TO CW_STAG;
 GRANT SELECT ON  CIS_LITER   TO CW_STAG;
-- 17.5.2007
 GRANT SELECT ON install2.obory TO cw_stag
-- 17.5.2007
 GRANT SELECT ON grupy_terminu TO cw_stag
 GRANT SELECT ON nadgrupy_terminu TO cw_stag
 GRANT SELECT ON studenti_na_zkouskach TO cw_stag
-- 7.6.2007
 GRANT execute ON FN_GET_ROK_PRO_ZAPIS_ZKOUSEK TO cw_stag;
 GRANT SELECT ON PARAMETRY_STAGU TO cw_stag
 GRANT SELECT ON pred_programy TO cw_stag
 GRANT SELECT ON np_pod TO cw_stag
 GRANT SELECT ON np_vyluc TO cw_stag
 GRANT SELECT ON pred_liter TO cw_stag
 GRANT SELECT ON cis_liter TO cw_stag

-- 1.11.2007
 grant execute on PR_GET_SYLABUS to cw_stag