Re: Proposing COPY .. WITH PERMISSIVE
| От | dinesh kumar |
|---|---|
| Тема | Re: Proposing COPY .. WITH PERMISSIVE |
| Дата | |
| Msg-id | CALnrH7osVrWHp4ksS-ciwW_T6WczrT1+uG25oWwTBe0ZW+CZFQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Proposing COPY .. WITH PERMISSIVE (Robert Haas <robertmhaas@gmail.com>) |
| Ответы |
Re: Proposing COPY .. WITH PERMISSIVE
|
| Список | pgsql-hackers |
Hi Robert/Andres,
On Thu, Jul 23, 2015 at 8:34 AM, Robert Haas <robertmhaas@gmail.com> wrote:
That doesn't sound like an especially good idea. What if I want mode 770?On Thu, Jul 23, 2015 at 11:32 AM, Andres Freund <andres@anarazel.de> wrote:
> On 2015-07-23 11:26:27 -0400, Robert Haas wrote:
>> On Wed, Jul 22, 2015 at 11:29 PM, dinesh kumar <dineshkumar02@gmail.com> wrote:
>> > Would like to propose PERMISSIVE mode for the COPY created out files.
>> > I mean, at this moment, if do "COPY" as postgres instance owner, i can able
>> > to read the file as non instance user as well, and would like to restrict
>> > this to
>> > instance owner WITH PERMISSIVE option.
>> >
>> > Let me know your thoughts on this.
>>
>> I don't understand the proposal.
>
> I understand it as PERMISSIVE := chmod 777 the target file of a COPY TO.
Sorry for my unclear description about the proposal.
"WITH PERMISSIVE" is equal to our existing behavior. That is, chmod=644 on the created files.
If User don't specify "PERMISSIVE" as an option, then the chmod=600 on created files. In this way, we can restrict the other users from reading these files.
Let me know if i am still bad at explaining things here.
Thanks in advance.
Regards,
Dinesh
В списке pgsql-hackers по дате отправления: