sanjay sharma <sanksh@hotmail.com> writes:
> 1. Transparent Data Encryption: The column which needs to be stored in encrypted form can be specified through DDL.
Theencryption key can be stored in a secure file accessible through a pass phrase. That particular column would apper
inencrypted form for all users except the users specified through a grant to see the data in decrypted form.
Exactly what threat do you see this protecting against, that wouldn't be
better solved by SQL-standard features like column-level access
permissions?
regards, tom lane