Re: Another user complaint regarding visibility of pg_catalog data - Mailing list pgsql-docs

From Laurenz Albe
Subject Re: Another user complaint regarding visibility of pg_catalog data
Date
Msg-id 4df5fbc8adbe770da13db92bc5cc48f948636640.camel@cybertec.at
Whole thread Raw
In response to Re: Another user complaint regarding visibility of pg_catalog data  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-docs
On Wed, 2023-11-08 at 05:31 -0700, David G. Johnston wrote:
> On Wednesday, November 8, 2023, Laurenz Albe <laurenz.albe@cybertec.at> wrote:
> > When people ask my "why?", I tend to answer "why not?".  It is not a security
> > problem, in my opinion.  Every user is allowed to know that I have a table
> > "purchase" with a column "credit_card_nr".  As long as the permissions are set
> > correctly, that is no problem.  Any attempt to hide that information is at best
> > "security by obscurity".
>
> The typical answer is some variant of trade secrets.  Though wanting to store
> private info in a comment has some merit too.

Don't keep your trade secrets in database identifiers or database function code.

But if somebody is nervous about that, they can have their own database.
Why share a database with users you don't trust?

Yours,
Laurenz Albe



pgsql-docs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: CREATE SUBSCRIPTION issue
Next
From: Laurenz Albe
Date:
Subject: Re: CREATE SUBSCRIPTION issue