
ALTER SESSION SET CURRENT_SCHEMA = CRONOSORA;

-- SE DEBE IR POR CONSOLA Y CREAR AL USUARIO
--gsec sysdba -password masterkey
--add USERAGENTE -pw kla7g8j

GRANT  SELECT ON  RELOJ  						TO USERAGENTE;
GRANT  SELECT ON  PARAMETRO_GENERAL 			TO USERAGENTE;
GRANT  SELECT ON  PROTOCOLO 					TO USERAGENTE;
GRANT  SELECT ON  USUARIO 						TO USERAGENTE;
GRANT  SELECT ON  REL_OPCION_OPERACION			TO USERAGENTE;
GRANT  SELECT ON  REL_PERFIL_OPCION_OPERACION	TO USERAGENTE;
GRANT  SELECT ON  PERFIL 						TO USERAGENTE;
GRANT  SELECT ON  OPCION 						TO USERAGENTE;
GRANT  SELECT ON  MODULO 						TO USERAGENTE;
GRANT  SELECT ON  REL_EMPRESA_MODULO 			TO USERAGENTE;
GRANT  SELECT ON  EMPRESA 						TO USERAGENTE;
GRANT  SELECT ON  REL_RELOJ_ZONA_APB 			TO USERAGENTE;
GRANT  SELECT ON  ZONA_APB 						TO USERAGENTE;
GRANT  SELECT ON  REL_PERFIL_RELOJ_HORARIO 		TO USERAGENTE;
GRANT  SELECT ON  HORARIO 						TO USERAGENTE;
GRANT  SELECT ON  TIPO_PERSONA 					TO USERAGENTE;
GRANT  SELECT ON  TIPO_ACCESO_RELOJ				TO USERAGENTE;
GRANT  SELECT ON  TIPO_RELOJ					TO USERAGENTE;
GRANT  SELECT ON  LECTURA_AUTOMATICA 			TO USERAGENTE;
GRANT  SELECT ON  PARAMETRO_IMPO 				TO USERAGENTE;
GRANT  SELECT ON  TIPO_PROCESO 					TO USERAGENTE;

GRANT  UPDATE ON  TARJETA_HISTORICO				TO USERAGENTE;

GRANT  INSERT ON  ERROR_TECNICO 				TO USERAGENTE;

GRANT  SELECT, UPDATE ON  AGENTE				TO USERAGENTE;
GRANT  SELECT, UPDATE ON  IDS_CONSOLA			TO USERAGENTE;
GRANT  SELECT, UPDATE ON  PERSONA 				TO USERAGENTE;

GRANT  SELECT, INSERT ON  REGISTRACION			TO USERAGENTE;
GRANT  SELECT, INSERT ON  CONSUMO_PERSONA 		TO USERAGENTE;
GRANT  SELECT, INSERT ON  CONSUMO_MENU 			TO USERAGENTE;

GRANT  SELECT, UPDATE, INSERT ON  DATO_PERMANENCIA TO USERAGENTE;

GRANT  SELECT, INSERT, DELETE ON  LOTE_AGENTE TO USERAGENTE;

GRANT  SELECT, UPDATE, DELETE, INSERT ON LOG_AGENTE TO USERAGENTE;