🏠 Menú principal

← Volver a tablas

---

SIMACMOBILE.SHEDLOCK

Base de datos origen: ORCLSMM

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	NAME	VARCHAR2(64)	NO
2	LOCK_UNTIL	TIMESTAMP(3)	SI
3	LOCKED_AT	TIMESTAMP(3)	SI
4	LOCKED_BY	VARCHAR2(255)	SI

Restricciones

PK: SYS_C00122484

• Estado: ENABLED
• Columnas: NAME

DDL

CREATE TABLE "SIMACMOBILE"."SHEDLOCK" 
   (	"NAME" VARCHAR2(64), 
	"LOCK_UNTIL" TIMESTAMP (3), 
	"LOCKED_AT" TIMESTAMP (3), 
	"LOCKED_BY" VARCHAR2(255), 
	 PRIMARY KEY ("NAME")
  USING INDEX  ENABLE
   ) ;

GRANT DELETE ON "SIMACMOBILE"."SHEDLOCK" TO "PERM_USUARIOAPP";
  GRANT INSERT ON "SIMACMOBILE"."SHEDLOCK" TO "PERM_USUARIOAPP";
  GRANT SELECT ON "SIMACMOBILE"."SHEDLOCK" TO "PERM_USUARIOAPP";
  GRANT UPDATE ON "SIMACMOBILE"."SHEDLOCK" TO "PERM_USUARIOAPP";
  GRANT UPDATE ON "SIMACMOBILE"."SHEDLOCK" TO "APLICACIONES";
  GRANT SELECT ON "SIMACMOBILE"."SHEDLOCK" TO "APLICACIONES";
  GRANT INSERT ON "SIMACMOBILE"."SHEDLOCK" TO "APLICACIONES";
  GRANT DELETE ON "SIMACMOBILE"."SHEDLOCK" TO "APLICACIONES";
  GRANT UPDATE ON "SIMACMOBILE"."SHEDLOCK" TO "CRUD_SIMAC";
  GRANT SELECT ON "SIMACMOBILE"."SHEDLOCK" TO "CRUD_SIMAC";
  GRANT INSERT ON "SIMACMOBILE"."SHEDLOCK" TO "CRUD_SIMAC";
  GRANT DELETE ON "SIMACMOBILE"."SHEDLOCK" TO "CRUD_SIMAC";
  GRANT SELECT ON "SIMACMOBILE"."SHEDLOCK" TO "CONSULTA";
  GRANT SELECT ON "SIMACMOBILE"."SHEDLOCK" TO "CONSULTA_SIMACMOBILE";
  GRANT DELETE ON "SIMACMOBILE"."SHEDLOCK" TO "USUARIO_SIMACMOBILE";
  GRANT INSERT ON "SIMACMOBILE"."SHEDLOCK" TO "USUARIO_SIMACMOBILE";
  GRANT UPDATE ON "SIMACMOBILE"."SHEDLOCK" TO "USUARIO_SIMACMOBILE";
  GRANT UPDATE ON "SIMACMOBILE"."SHEDLOCK" TO "EXECUTE_SIMACMOBILE";
  GRANT INSERT ON "SIMACMOBILE"."SHEDLOCK" TO "EXECUTE_SIMACMOBILE";
  GRANT DELETE ON "SIMACMOBILE"."SHEDLOCK" TO "EXECUTE_SIMACMOBILE";
  GRANT DELETE ON "SIMACMOBILE"."SHEDLOCK" TO "RAPLICACIONES";
  GRANT INSERT ON "SIMACMOBILE"."SHEDLOCK" TO "RAPLICACIONES";
  GRANT SELECT ON "SIMACMOBILE"."SHEDLOCK" TO "RAPLICACIONES";
  GRANT UPDATE ON "SIMACMOBILE"."SHEDLOCK" TO "RAPLICACIONES";

CREATE UNIQUE INDEX "SIMACMOBILE"."SYS_C00122484" ON "SIMACMOBILE"."SHEDLOCK" ("NAME") 
  ;

---

← Volver a tablas de SIMACMOBILE

🏠 Volver al menú principal