Re: Hiding name and version

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.