I'm working on a database design in which I've run into an amusing
problem. I've got a workaround that's "good enough" but it's not very
I can't talk about the real application so I'll use some suitable
Suppose you have a table of angels. Angels are required to be above
Unfortunately angels do sometimes blot their resume and have to serve
In my real application the privacy of the people I'm calling angels
I keep information about angelic transgressions is in a separate sins
If an angel has never transgressed they will have no row in the sins
Thus merely leaking the existence of a row would embarrass an angel,
I can easily prevent access to the sins table with suitable grants but I
I originally wanted to encrypt the foreign key in the sins table that
Unfortunately it seems Ingres column encryption isn't compatible with a
So, I'm open to suggestions. Hardware-level encryption seems like a
Alternatively, am I mis-using encryption? Is it possible to do what I
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.