Re: Disable copy function

From: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
To: prasanna rk <prasanna2mail(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Disable copy function
Date: 2018-11-30 09:18:01
Message-ID: 8736rjlyfd.fsf@news-spur.riddles.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

>>>>> "prasanna" == prasanna rk <prasanna2mail(at)gmail(dot)com> writes:

prasanna> Hi Team
prasanna> How do I disable copy option from database, i understand
prasanna> usually this option will be available only for super user,
prasanna> however we need to disable fully from DB.. please advice

Why?

Notice that the superuser has other ways to read and write files (for
example lo_import/lo_export, pg_read_file, using ALTER SYSTEM to
change the log directory and filename, loading a module to call the OS,
using file access functions in any untrusted language, etc. etc.)

--
Andrew (irc:RhodiumToad)

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron 2018-11-30 09:34:12 Re: Disable copy function
Previous Message David G. Johnston 2018-11-30 05:04:41 Re: Disable copy function