1.175 LOB_SIGNATURE_ENABLE
LOB_SIGNATURE_ENABLE is used to enable or disable the LOB locator signature feature.
| Property | Description |
|---|---|
|
Parameter type |
Boolean |
|
Default value |
|
|
Modifiable |
|
|
Modifiable in a PDB |
Yes |
|
Range of values |
|
|
Basic |
No |
|
Oracle RAC |
Multiple instances must have the same value. |
You can secure your LOBs by enabling the LOB locator signature feature. A LOB locator is a pointer to the location of a large object (LOB) value. If the LOB_SIGNATURE_ENABLED initialization parameter is set to true, then when you create a LOB, Oracle Database automatically assigns a signature to the LOB locator. When Oracle Database receives a request from a client, it uses the signature to determine if any tampering with the LOB locator has occurred.
When this parameter is set to true, you also have the option of further securing your LOBs by encrypting your LOB locator signature keys.
Note:
This parameter is available starting with Oracle Database 19c, Release Update 19.1.
See Also:
Oracle Database Security Guide for more information on LOB locator signatures and encrypting LOB locator signature keys