Re: security label and indexes - Mailing list pgsql-general

From Tom Lane
Subject Re: security label and indexes
Date
Msg-id 3552327.1669149186@sss.pgh.pa.us
Whole thread Raw
In response to security label and indexes  (Ted Toth <txtoth@gmail.com>)
List pgsql-general
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



pgsql-general by date:

Previous
From: Erik Wienhold
Date:
Subject: Re: copying json data and backslashes
Next
From: Brad White
Date:
Subject: Re: Upgrading to v12