Re: Sequence vs UUID

Поиск
Список
Период
Сортировка
От Erik Wienhold
Тема Re: Sequence vs UUID
Дата
Msg-id 1015127885.422245.1674938371999@office.mailbox.org
обсуждение исходный текст
Ответ на Re: Sequence vs UUID  (Ron <ronljohnsonjr@gmail.com>)
Список pgsql-general
> On 27/01/2023 01:48 CET Ron <ronljohnsonjr@gmail.com> wrote:
>
> On 1/26/23 15:55, Erik Wienhold wrote:
> >
> > There are arguments against sequential PK, e.g. they give away too much info and
> > allow attacks such as forced browsing[2].  The first I can understand: you may
> > not want to reveal the number of users or customers.  But access control should
> > prevent forced browsing.
>
> Shouldn't your application layer isolate the users from the database?  UUIDs
> are all over the DBs I manage, but the PKs are all sequences.

Yes, I meant the application layer, not Postgres' access control.

--
Erik



В списке pgsql-general по дате отправления:

Предыдущее
От: Erik Wienhold
Дата:
Сообщение: Re: Why is this SELECT evaluated?
Следующее
От: Christophe Pettus
Дата:
Сообщение: Re: Why is this SELECT evaluated?