Good to know.
Thanks everyone.
-Original Message-
From: Jerry Sievers [mailto:gsiever...@comcast.net]
Sent: Thursday, September 17, 2015 11:03 PM
To: Tom Lane
Cc: Joshua D. Drake; Quiroga, Damian; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Hiding name and version
Tom Lane
Tom Lane writes:
> "Joshua D. Drake" writes:
>
>> On 09/17/2015 10:32 AM, Quiroga, Damian wrote:
>>> Is it possible to prevent users from running the version function or
>>> all system information functions? If so, how?
>
>> You could probably revoke access to the function(s) (I haven't tried
"Quiroga, Damian" writes:
> I've tried something like "REVOKE EXECUTE ON FUNCTION version() FROM
> someuser;" and it doesn't work.
> Apparently you can only revoke permissions that you have explicitly granted
> before.
The default behavior for built-in functions is as though the bootstrap
super
"Joshua D. Drake" writes:
> On 09/17/2015 10:32 AM, Quiroga, Damian wrote:
>> Is it possible to prevent users from running the version function or
>> all system information functions? If so, how?
> You could probably revoke access to the function(s) (I haven't tried it
> because it seems very
a D. Drake [mailto:j...@commandprompt.com]
Sent: Thursday, September 17, 2015 3:05 PM
To: Quiroga, Damian; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Hiding name and version
On 09/17/2015 10:32 AM, Quiroga, Damian wrote:
> Hi,
>
> Is it possible to prevent users from running the
On 09/17/2015 10:32 AM, Quiroga, Damian wrote:
Hi,
Is it possible to prevent users from running the “version” function or
all system information functions? If so, how?
You could probably revoke access to the function(s) (I haven't tried it
because it seems very silly).
JD
--
Command Promp
