Bruce Momjian <bruce@momjian.us> writes:
> I am confused how knowing that a sequence number used for a primary key
> exists or doesn't exist is leaking _meaningful_ information. People
> might know the sequence number exists, but how is that information
> useful. Now, if natural keys are used, that is a different story.
Right. It might be that securing a database requires not just some
security mechanisms but also some database design rules (like "don't
allow foreign keys except on synthetic IDs"). But it seems to me that
we are just flailing around in the dark because we don't have that
bigger picture of how the features would actually get used.
The literature pointers that Andrew just gave us seem promising to me.
Who's going to go searching for some useful info?
regards, tom lane