Thanks for your answer.
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.
Any other ideas?
Damian
-----Original Message-----
From: Joshua D. Drake [mailto:jd@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 "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 Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564 PostgreSQL Centered full stack support, consulting
anddevelopment.
Announcing "I'm offended" is basically telling the world you can't control your own emotions, so everyone else should
doit for you.