Re: policies and extensions

On 2/17/20 2:46 PM, Marc Munro wrote:
> I tried to define a policy within an extension but the policy does not
> seem to belong to the extension.  Is this the way it is supposed to be?
> 
> This is postgres 9.5.21
> 
> Here is the relevant code from the extension:
> 
>      create table rls2 (
>        username text not null,
>        details  text not null
>      );
> 
>      create policy only_owner on rls2
>        for all
>        to session_user
>        using (username = user);
> 
> The table, as expected, depends on the extension but the policy does
> not (determined by querying pg_depend).
> 
> Am I missing something special about policies or is this an oversight?

?:
https://www.postgresql.org/docs/9.5/sql-createpolicy.html

"The CREATE POLICY command defines a new row-level security policy for a 
table. Note that row-level security must be enabled on the table (using 
ALTER TABLE ... ENABLE ROW LEVEL SECURITY) in order for created policies 
to be applied."

> 
> __
> Marc
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com