Re: security label and indexes

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ted Toth <txtoth(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: security label and indexes
Date: 2022-11-22 20:33:06
Message-ID: 3552327.1669149186@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ted Toth <txtoth(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Brad White 2022-11-22 20:53:01 Re: Upgrading to v12
Previous Message Erik Wienhold 2022-11-22 19:39:46 Re: copying json data and backslashes