ConsolidatedOracleDatabaseUser Template
ConsolidatedOracleDatabaseUser provides a list of the users for each Oracle database instance.
Column |
Details |
---|---|
UserID
|
Type: big integer. Key The identifier used in the source connection for the instance end-user. This may be an integer or a string. Destination:
|
ComputerID
|
Type: big integer. Key The identifier used in the source connection for the computer. It must match the ComputerID from the Computer spreadsheet or the row will be ignored. Destination:
|
InstanceName
|
Type: big integer. Key This field specifies the name of the database instance. If there are multiple instances, create a row for each instance in this spreadsheet. It must match a row in the InstallerEvidence spreadsheet for the same ComputerID or this row will be skipped. Destination:
|
Name
|
Type: text (max 256 characters) The name of the user. Destination:
|
AccountStatus
|
Type: text (max 256 characters). Nullable The current status of the end-user account. Destination:
|
CreationDate
|
Type: datetime. Nullable The date and time when the end-user was created. The date must be entered in one of the supported formats. Possible values:
Destination:
|
LastLogonDate
|
Type: datetime. Nullable The date and time when the end-user last logged on to the computer. The date must be entered in one of the supported formats. Possible values:
Destination:
|
DefaultTablespace
|
Type: text (max 256 characters). Nullable The default tablespace for an Oracle end-user. Destination:
|
TempTablespace
|
Type: text (max 256 characters). Nullable The temporary tablespace for an Oracle end-user. Destination:
|
DisplayName
|
Type: text (max 256 characters). Key The display name of the software as reported by the installer evidence. It must match a row in the InstallerEvidence spreadsheet for the same ComputerID, Version, Publisher and InstanceName or this row will be skipped. Destination:
|
Version
|
Type: text (max 72 characters). Key The version of the software as reported by the installer evidence. It must match a row in the InstallerEvidence spreadsheet for the same ComputerID, DisplayName, Publisher and InstanceName or this row will be skipped. Destination:
|
Publisher
|
Type: text (max 200 characters). Key The publisher of the software as reported by the installer evidence. It must match a row in the InstallerEvidence spreadsheet for the same ComputerID, DisplayName, Version and InstanceName or this row will be skipped. Destination:
|
Evidence
|
Type: text (max 32 characters). Key. Nullable Identifier for the type of installer evidence. Destination:
|
AccessMode
|
Type: text (max 128 characters). Key. Nullable The access mode of the installer evidence. Leave this blank unless this row is a virtualized application. In that case choose one of the values below that matches your application or desktop virtualization infrastructure. Possible values:
Destination:
|