/************************************************************************
 * Name     :create_system.sql						*
 * Issue    :03-09-2003 - H. Korte - Intevation - Osnabrueck		*	
 * Purpose  :set privileges 						*
 *           you can edit the type of prvilege and the acceptor		* 
 *	     e.g. grant create on user_tab to <username>		*	
 * Parameter:								*
 * Changes  :								*
 * [ Date   ] - [ Name ] - [ Action ]					*
 ************************************************************************/
 
GRANT ALL ON USER_TAB TO PUBLIC;
GRANT ALL ON GROUP_TAB TO PUBLIC;
GRANT ALL ON STRETCH_TAB TO PUBLIC;
GRANT ALL ON STRETCH_CLASS_TAB TO PUBLIC;
GRANT ALL ON CATCH_TAB TO PUBLIC;
GRANT ALL ON SESS_TAB TO PUBLIC;
GRANT ALL ON BACKGRD_JOIN_TAB TO PUBLIC;
GRANT ALL ON BIN_OBJ_TAB TO PUBLIC;
GRANT ALL ON BIN_OBJ_SEARCH_TAB TO PUBLIC;
GRANT ALL ON DISCH_TAB TO PUBLIC;
GRANT ALL ON DISCH_CLASS_TAB TO PUBLIC;
GRANT ALL ON PARA_TREE_DEF_TAB TO PUBLIC;
GRANT ALL ON SESS_TAB TO PUBLIC;
GRANT ALL ON SESS_DISCH_TAB TO PUBLIC;
GRANT ALL ON MARKET_TAB TO PUBLIC;
GRANT ALL ON RES_TAB TO PUBLIC;
GRANT ALL ON RES_STRETCH_TAB TO PUBLIC;
GRANT ALL ON RES_DISCH_TAB TO PUBLIC;
GRANT ALL ON SUBST_TAB TO PUBLIC;
GRANT ALL ON SUBST_DET_TAB TO PUBLIC;
GRANT ALL ON ENV_TAB TO PUBLIC;
GRANT ALL ON ENV_DET_TAB TO PUBLIC;
GRANT ALL ON MOD_TAB TO PUBLIC;
GRANT ALL ON MOD_DET_TAB TO PUBLIC;
GRANT ALL ON PHRASE_TAB TO PUBLIC;
GRANT ALL ON MESSAGE_TAB TO PUBLIC; 

GRANT ALL ON CATCH_SEQ TO PUBLIC;
GRANT ALL ON SUBST_SEQ TO PUBLIC;
GRANT ALL ON SESS_SEQ TO PUBLIC;
GRANT ALL ON SUBST_DET_SEQ TO PUBLIC;
GRANT ALL ON ENV_SEQ TO PUBLIC;
GRANT ALL ON ENV_DET_SEQ TO PUBLIC;
GRANT ALL ON MOD_DET_SEQ TO PUBLIC;
GRANT ALL ON MOD_SEQ TO PUBLIC;
GRANT ALL ON MARKET_SEQ TO PUBLIC;
GRANT ALL ON RES_SEQ TO PUBLIC;
GRANT ALL ON RES_STRETCH_SEQ TO PUBLIC;
GRANT ALL ON RES_DISCH_SEQ TO PUBLIC;
GRANT ALL ON SESS_DISCH_SEQ TO PUBLIC;
GRANT ALL ON PHRASE_SEQ TO PUBLIC;
GRANT ALL ON GROUP_SEQ TO PUBLIC;
GRANT ALL ON BIN_OBJ_SEQ TO PUBLIC;
