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

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