Thread: lo_export and files permissions
De: Mike Baroukh <mike.baroukh@netcourrier.com> À: <pgsql-sql@postgresql.org> Objet: lo_export and files permissions Date : lundi 14 août 2000 10:44 Hi everybody. Who can help me with a lo_export() problem ? : I'm using lo_export function in sql statement with pgsql 6.5 on Linux RH 6.2. Data are exported fine. My problem is I can't delete created objects cause they have writing permissions for user postgres only. I tried changing umask for postmaster with no success. When I try to delete, it's within a servlet so running as user nobody.what would be fine is adding write permissions to grouppostgres so I can add nobody to this group ... Thanks in advance for your help. Mike Baroukh i-panema - 14 Rue Ballu Paris IXeme 06 63 57 27 22 Mike Baroukh i-panema - 10 rue Ballu - 75009 Paris 06 63 57 27 22 ----- La messagerie itinérante sans abonnement NetCourrier ----- Web : www.netcourrier.com Minitel : 3615 et 3623 NETCOURRIER Tél : 08 36 69 00 21
Hi, I was using sql lo_export function before upgraded to 7.0 (which doesn't allow non-admin to call it). So if possible, you can use the client function lo_export to extract the blob. I know it's simple in Perl DBI but not sure about java. Another work-around might be to lo_export the file to a directory writable by nobody. Regards, -- Guo Bin --- mike.baroukh@netcourrier.com wrote: > De: Mike Baroukh <mike.baroukh@netcourrier.com> > �: <pgsql-sql@postgresql.org> > Objet: lo_export and files permissions > Date�: lundi 14 ao�t 2000 10:44 > > Hi everybody. > > Who can help me with a lo_export() problem ? : > > I'm using lo_export function in sql statement with pgsql > 6.5 on Linux RH 6.2. > Data are exported fine. > My problem is I can't delete created objects cause they > have writing permissions for user postgres only. > I tried changing umask for postmaster with no success. > When I try to delete, it's within a servlet so running as > user nobody.what would be fine is adding write > permissions to group postgres so I can add nobody to this > group ... > > Thanks in advance for your help. > > > Mike Baroukh > i-panema - 14 Rue Ballu Paris IXeme > 06 63 57 27 22 > > Mike Baroukh > i-panema - 10 rue Ballu - 75009 Paris > 06 63 57 27 22 > > ----- La messagerie itin�rante sans abonnement > NetCourrier ----- > Web : www.netcourrier.com Minitel : 3615 et 3623 > NETCOURRIER > T�l : 08 36 69 00 21 __________________________________________________ Do You Yahoo!? Send instant messages & get email alerts with Yahoo! Messenger. http://im.yahoo.com/
Hi, > I was using sql lo_export function before upgraded to > 7.0 (which doesn't allow non-admin to call it). So if > possible, you can use the client function lo_export to > extract the blob. I know it's simple in Perl DBI but > not sure about java. I actually use lo_export with java. But this only allow to export dta, not to delete exported data ?? > Another work-around might be to lo_export the file > to a directory writable by nobody. I tried, don't work. In fact, I can delete by hand, even if i'm not root or postgres by using command "rm -f". But I can't delete using Java's File object. Mike ----- Original Message ----- From: Guo Bin <guobin_@yahoo.com> To: <mike.baroukh@netcourrier.com>; <pgsql-sql@postgresql.org> Sent: Wednesday, August 16, 2000 11:31 AM Subject: Re: [SQL] lo_export and files permissions > Hi, > I was using sql lo_export function before upgraded to > 7.0 (which doesn't allow non-admin to call it). So if > possible, you can use the client function lo_export to > extract the blob. I know it's simple in Perl DBI but > not sure about java. > Another work-around might be to lo_export the file > to a directory writable by nobody. > > Regards, > -- > Guo Bin > > --- mike.baroukh@netcourrier.com wrote: > > De: Mike Baroukh <mike.baroukh@netcourrier.com> > > À: <pgsql-sql@postgresql.org> > > Objet: lo_export and files permissions > > Date : lundi 14 août 2000 10:44 > > > > Hi everybody. > > > > Who can help me with a lo_export() problem ? : > > > > I'm using lo_export function in sql statement with pgsql > > 6.5 on Linux RH 6.2. > > Data are exported fine. > > My problem is I can't delete created objects cause they > > have writing permissions for user postgres only. > > I tried changing umask for postmaster with no success. > > When I try to delete, it's within a servlet so running as > > user nobody.what would be fine is adding write > > permissions to group postgres so I can add nobody to this > > group ... > > > > Thanks in advance for your help. > > > > > > Mike Baroukh > > i-panema - 14 Rue Ballu Paris IXeme > > 06 63 57 27 22 > > > > Mike Baroukh > > i-panema - 10 rue Ballu - 75009 Paris > > 06 63 57 27 22 > > > > ----- La messagerie itinérante sans abonnement > > NetCourrier ----- > > Web : www.netcourrier.com Minitel : 3615 et 3623 > > NETCOURRIER > > Tél : 08 36 69 00 21 > > > __________________________________________________ > Do You Yahoo!? > Send instant messages & get email alerts with Yahoo! Messenger. > http://im.yahoo.com/ >