Re: temp table security labels - Mailing list pgsql-general

From Ted Toth
Subject Re: temp table security labels
Date
Msg-id CAFPpqQH=WFzOVodZwzhzxmjJ08LAZQ+2rv4ZROjm18kS34p8aQ@mail.gmail.com
Whole thread Raw
In response to Re: temp table security labels  (Ted Toth <txtoth@gmail.com>)
Responses Re: temp table security labels
List 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@gmail.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@gmail.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



pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: track_activity_query_size max practical size?
Next
From: Ted Toth
Date:
Subject: Re: temp table security labels