Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
OLC_OH_Idnr int NUMBER(38,0) int int false ID of the login object.
OLC_Type varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) false Type of the password according to HostAttrType (=platform of the agent)
OLC_Host varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) false Name of the agent.
OLC_Login varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) false Login information.
OLC_Pw varbinary(63) RAW(63) varchar(63) for bit data bytea true Currently unused.
OLC_PwKey varbinary(16) RAW(16) varchar(16) for bit data bytea true Currently unused.
OLC_Pw1 varbinary(max) BLOB blob(20480 k) COMPACT bytea true The encrypted password #1.
OLC_Pw2 varbinary(max) BLOB blob(20480 k) COMPACT bytea true The encrypted password #2.
OLC_Pw3 varbinary(max) BLOB blob(20480 k) COMPACT bytea true The encrypted password #3.
OLC_Pw4 varbinary(max) BLOB blob(20480 k) COMPACT bytea true The encryption key.
OLC_Vault varchar (255) VARCHAR2 (255 CHAR) varchar(255) varchar (255) true AutomationEngine or external vault (e.g. CyberArk)
OLC_IsUtf8 smallint NUMBER(38,0) smallint smallint true Indicates if OLC_Pw1-4 are stored in UTF-8 (1) or legacy encoding (0)

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_OLC OLC_OH_Idnr, OLC_Type, OLC_Host true true true false

Foreign Keys:

Name Local References Foreign References
FK_OLC_OH OLC_OH_Idnr OH_Idnr

Return to the Index File