On Thu, Jul 23, 2015 at 9:21 AM, Robert Haas <robertmh...@gmail.com> wrote:
> On Thu, Jul 23, 2015 at 12:19 PM, dinesh kumar <dineshkuma...@gmail.com> > wrote: > > 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. > > There might be some benefit in allowing the user to choose the > permissions, but (1) I doubt we want to change the default behavior > and (2) providing only two options doesn't seem flexible enough. > > Thanks for your inputs Robert. 1) IMO, we will keep the exiting behavior as it is. 2) As the actual proposal talks about the permissions of group/others. So, we can add few options as below to the WITH clause COPY .. .. WITH [ NO (READ,WRITE) PERMISSION TO (GROUP,OTHERS) ] Best Regards, Dinesh manojadinesh.blogspot.com > -- > Robert Haas > EnterpriseDB: http://www.enterprisedb.com > The Enterprise PostgreSQL Company >