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

 -- 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;