pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
security label and indexes
2+ messages / 2 participants
[nested] [flat]

* security label and indexes
@ 2022-11-22 19:04  Ted Toth <txtoth@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Ted Toth @ 2022-11-22 19:04 UTC (permalink / raw)
  To: pgsql-general@lists.postgresql.org

I noticed that the 'security label' sql command does not include indexes as
objects that can be labeled, why is that? What sepgsql security class are
indexes, db_table?

Ted

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: security label and indexes
@ 2022-11-22 20:33  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Ted Toth <txtoth@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2022-11-22 20:33 UTC (permalink / raw)
  To: Ted Toth <txtoth@gmail.com>; +Cc: pgsql-general@lists.postgresql.org

Ted Toth <txtoth@gmail.com> writes:
> I noticed that the 'security label' sql command does not include indexes as
> objects that can be labeled, why is that? What sepgsql security class are
> indexes, db_table?

Indexes don't have security labels, just as they don't have SQL
permissions.  From a security standpoint, they're implementation
details of the table they belong to.  Whatever usage restrictions
you want should be put on the table, instead.

			regards, tom lane





^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2022-11-22 20:33 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-11-22 19:04 security label and indexes Ted Toth <txtoth@gmail.com>
2022-11-22 20:33 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox