🏠 Menú principal

← Volver a tablas

---

LACLS.LACLS_CO_SECURITY_USERS

Base de datos origen: PDB1

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	LEDGER_ID	NUMBER	SI
2	BALANCING_SEGMENT	VARCHAR2(25)	SI
3	USERNAME	VARCHAR2(100)	SI
4	ADD_ATT1	VARCHAR2(150)	SI
5	ADD_ATT2	VARCHAR2(150)	SI
6	ADD_ATT3	VARCHAR2(150)	SI
7	ADD_ATT4	VARCHAR2(150)	SI
8	ADD_ATT5	VARCHAR2(150)	SI
9	ADD_ATT6	VARCHAR2(150)	SI
10	ADD_ATT7	VARCHAR2(150)	SI
11	ADD_ATT8	VARCHAR2(150)	SI
12	ADD_ATT9	VARCHAR2(150)	SI
13	ADD_ATT10	VARCHAR2(150)	SI
14	ADD_ATT11	VARCHAR2(150)	SI
15	ADD_ATT12	VARCHAR2(150)	SI
16	ADD_ATT13	VARCHAR2(150)	SI
17	ADD_ATT14	VARCHAR2(150)	SI
18	ADD_ATT15	VARCHAR2(150)	SI
19	CREATION_DATE	DATE	SI
20	CREATED_BY	VARCHAR2(64)	SI
21	LAST_UPDATE_DATE	DATE	SI
22	LAST_UPDATED_BY	VARCHAR2(64)	SI
23	LAST_UPDATE_LOGIN	VARCHAR2(32)	SI

Restricciones

Sin restricciones visibles (P/R/U/C).

DDL

CREATE TABLE "LACLS"."LACLS_CO_SECURITY_USERS" 
   (	"LEDGER_ID" NUMBER, 
	"BALANCING_SEGMENT" VARCHAR2(25), 
	"USERNAME" VARCHAR2(100), 
	"ADD_ATT1" VARCHAR2(150), 
	"ADD_ATT2" VARCHAR2(150), 
	"ADD_ATT3" VARCHAR2(150), 
	"ADD_ATT4" VARCHAR2(150), 
	"ADD_ATT5" VARCHAR2(150), 
	"ADD_ATT6" VARCHAR2(150), 
	"ADD_ATT7" VARCHAR2(150), 
	"ADD_ATT8" VARCHAR2(150), 
	"ADD_ATT9" VARCHAR2(150), 
	"ADD_ATT10" VARCHAR2(150), 
	"ADD_ATT11" VARCHAR2(150), 
	"ADD_ATT12" VARCHAR2(150), 
	"ADD_ATT13" VARCHAR2(150), 
	"ADD_ATT14" VARCHAR2(150), 
	"ADD_ATT15" VARCHAR2(150), 
	"CREATION_DATE" DATE, 
	"CREATED_BY" VARCHAR2(64), 
	"LAST_UPDATE_DATE" DATE, 
	"LAST_UPDATED_BY" VARCHAR2(64), 
	"LAST_UPDATE_LOGIN" VARCHAR2(32)
   ) ;

GRANT DELETE ON "LACLS"."LACLS_CO_SECURITY_USERS" TO "SOPORTE_COE";
  GRANT INSERT ON "LACLS"."LACLS_CO_SECURITY_USERS" TO "SOPORTE_COE";
  GRANT SELECT ON "LACLS"."LACLS_CO_SECURITY_USERS" TO "SOPORTE_COE";
  GRANT UPDATE ON "LACLS"."LACLS_CO_SECURITY_USERS" TO "SOPORTE_COE";

---

← Volver a tablas de LACLS

🏠 Volver al menú principal