Re: temp table security labels

From: Ted Toth <txtoth(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: temp table security labels
Date: 2023-07-07 15:44:17
Message-ID: CAFPpqQH=WFzOVodZwzhzxmjJ08LAZQ+2rv4ZROjm18kS34p8aQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I see it now sepgsql_schema_post_create is doing it ... it's just not
doing what I think it should :(

On Fri, Jul 7, 2023 at 8:05 AM Ted Toth <txtoth(at)gmail(dot)com> wrote:
>
> Also AFAICT the schema created for the temp table does not get deleted
> at the end of the session which also causes issues.
>
> On Fri, Jul 7, 2023 at 7:43 AM Ted Toth <txtoth(at)gmail(dot)com> wrote:
> >
> > I'm seeing security labels set on db objects when a temporary table is
> > created but they don't match the labels I've configured in my
> > sepgsql_contexts file. Our code doesn't actually execute a "SECURITY
> > LABEL ..." command for the temp tables but something else must be
> > doing so because I see pg_temp_NNN in pg_seclabels. So I'm confused at
> > how the objects are being labeled, can anyone help me understand how
> > this is happening?
> >
> > Ted

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ted Toth 2023-07-07 15:52:13 Re: temp table security labels
Previous Message Ron 2023-07-07 15:27:27 Re: track_activity_query_size max practical size?