Postgres Pro
Downloads
Home   >   mailing lists

Re: Loggingt psql meta-commands - Mailing list pgsql-general

From oleg yusim
Subject Re: Loggingt psql meta-commands
Date
Msg-id CAKd4e_GaJ7xw8Ryi0=p-NLT_a2wW5aGLz4CZKQk-1Pf-2c-2Rg@mail.gmail.com
Whole thread Raw
In response to Re: Loggingt psql meta-commands  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Loggingt psql meta-commands  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
Hi David,

Can you, please, give me example?

Thanks,

Oleg

On Thu, Dec 10, 2015 at 2:25 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Thu, Dec 10, 2015 at 1:20 PM, oleg yusim <olegyusim@gmail.com> wrote:
Also... how do we control who can run meta commands?

​You cannot do so directly but you can control permissions to the underlying schema that the meta-command queries touch so that attempting to run the meta-command fails.

This is not as simple as it may seem; visibility of the schema is considerably more permissive than visibility of data.

David J.​
 


pgsql-general by date:

Previous
From: "Corradini, Carlos"
Date:
Subject: [JDBC] plpgsql function with RETURNS SETOF refcursor in JAVA
Next
From: "David G. Johnston"
Date:
Subject: Re: Loggingt psql meta-commands