"Joshua D. Drake" <jd@xxxxxxxxxxxxxxxxx> 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 silly). I believe revoking public execute access would work, but I concur that this specific request seems entirely pointless. Anyone with SQL-level access to the server, and a copy of the release notes, can soon determine what version they are talking to by testing for the presence or absence of assorted features and bugs. Keep in mind also that pg_dump or pg_upgrade would not preserve such alterations to system functions. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
