Re: COPY INTO FILE - Folder permission

8 Sep 2018


      How are you running mserver5?  It looks like it is running as root
(extremely bad idea, by the way), so how does it get started?  It's the
mserver4 process that writes the file, so the umask Stefan mentioned
applied to it.

On 08/09/2018 13.32, Ariel Abadi wrote:
...
Stefan
Thanks for your info... but, unfortunately didnt work.
Ive run it with my user which has umask 0002 and when the file was
created by monet, was create RW only for my user :(
Thanks either!
Rgds
Ariel 
*/Ariel Abadi/*
Direct: +54 11 5279.2054
Mobile:+54 9 11 6050.0101
Email: aabadi@starbi.com mailto:aabadi@starbi.com
Web: www.starbi.com http://www.starbi.com/
On Fri, Sep 7, 2018 at 5:45 PM, Stefan Manegold mailto:Stefan.Manegold@cwi.nl> wrote:
Hi,
IMHO the file permissions are determined by the umask
    of the user/shell/process that started merser5.
Best,
    Stefan
----- On Sep 7, 2018, at 9:24 PM, Ariel Abadi
    aabadi@starconnecting.com mailto:aabadi@starconnecting.com wrote:
> Hi!
    > We are running some "exports" using the COPY INTO FILE, the
    problem we are
    > facing is that the file created by monetdb is Read Write ONLY by
    the user
    > running the database.
    >
    > -rw------- 1 root monet 9477 Sep 7 15:08 exp.csv
    >
    > Is there any way so the created file has also RW permission to the
    group and NOT
    > only the user.
    >
    > In this case, we are using an NFS share so we are not able to use
    setfacl.
    >
    > Does anybody has an idea how to solve this ?
    >
    > Thanks a lot in advance!
    > Rgds
    > Ariel
    >
    >
    > _______________________________________________
    > users-list mailing list
    > users-list@monetdb.org mailto:users-list@monetdb.org
    > https://www.monetdb.org/mailman/listinfo/users-list
    https://www.monetdb.org/mailman/listinfo/users-list
-- 
    | Stefan.Manegold@CWI.nl | DB Architectures   (DA) |
    | www.CWI.nl/~manegold/ http://www.CWI.nl/~manegold/  | Science
    Park 123 (L321) |
    | +31 (0)20 592-4212     | 1098 XG Amsterdam  (NL) |
    _______________________________________________
    users-list mailing list
    users-list@monetdb.org mailto:users-list@monetdb.org
    https://www.monetdb.org/mailman/listinfo/users-list
    https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list
-- 
Sjoerd Mullender