This content has been marked as final. Show 3 replies
When set that attribute to "Yes" item value is encrypt when it is stored to APEX session state.
Admin or developer can not see users plain value when query e.g. APEX views.
Session state that is sensitive can be encrypted when stored in Application Express session state management tables. To maintain session state encrypted for this item set the value to Yes. Values up to 4000 bytes in length can be encrypted. Attempts to encrypt values longer than 4000 bytes will produce an error message.
My Blog: http://dbswh.webhop.net/htmldb/f?p=BLOG:HOME:0
Thanks for your response Jarola, but could you give me a practical example of where I would use this. I'm a bit confused about what the user sees and what a developer would see.
thanks in advance
Here's a practical example...
Let's say you have an application that stores PII (Personally Identifiable Information). You don't want developers and/or DBAs to see that information by querying the session state tables underneath APEX, so you enable Session State Encryption.
You could also use Data Vault to then protect that information when it goes into your application tables (not the APEX tables, your tables).