Skip to content

DBA Data[Home] [Help] [Dependency Information]

VIEW: IBY.IBY_SYS_SECURITY_OPTIONS#

Object Details
Object Name: IBY_SYS_SECURITY_OPTIONS#
Object Type: VIEW
Owner: IBY
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
SYS_KEY_FILE_LOCATION VARCHAR2 (500)
SYS_KEY_HASH RAW (100)
CC_ENCRYPTION_MODE VARCHAR2 (30) Yes
EXT_BA_ENCRYPTION_MODE VARCHAR2 (30) Yes
INSTR_SEC_CODE_ENCRYPTION_MODE VARCHAR2 (30) Yes
CREDIT_CARD_MASK_SETTING VARCHAR2 (30) Yes
CREDIT_CARD_UNMASK_LEN NUMBER (2)
EXT_BA_MASK_SETTING VARCHAR2 (30) Yes
EXT_BA_UNMASK_LEN NUMBER (2)
SUBKEY_USE_MAXIMUM NUMBER (10) Yes
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
OBJECT_VERSION_NUMBER NUMBER (15) Yes
SALT_VERSION NUMBER (2)
SUBKEY_AGE_MAXIMUM NUMBER (3)
ENCRYPT_SUPPLEMENTAL_CARD_DATA VARCHAR2 (1)
ENCRYPTION_PATCH_LEVEL VARCHAR2 (30)
SYSTEM_SALT_VERSION NUMBER (2)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SYS_KEY_FILE_LOCATION
,      SYS_KEY_HASH
,      CC_ENCRYPTION_MODE
,      EXT_BA_ENCRYPTION_MODE
,      INSTR_SEC_CODE_ENCRYPTION_MODE
,      CREDIT_CARD_MASK_SETTING
,      CREDIT_CARD_UNMASK_LEN
,      EXT_BA_MASK_SETTING
,      EXT_BA_UNMASK_LEN
,      SUBKEY_USE_MAXIMUM
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      SALT_VERSION
,      SUBKEY_AGE_MAXIMUM
,      ENCRYPT_SUPPLEMENTAL_CARD_DATA
,      ENCRYPTION_PATCH_LEVEL
,      SYSTEM_SALT_VERSION
FROM IBY.IBY_SYS_SECURITY_OPTIONS#;

Dependencies

[top of page]

IBY.IBY_SYS_SECURITY_OPTIONS# references the following:

SchemaIBY
TableIBY_SYS_SECURITY_OPTIONS
IBY.IBY_SYS_SECURITY_OPTIONS# is referenced by following:

SchemaAPPS
SynonymIBY_SYS_SECURITY_OPTIONS