Path: utzoo!attcan!uunet!zaphod.mps.ohio-state.edu!tut.cis.ohio-state.edu!pt.cs.cmu.edu!o.gp.cs.cmu.edu!andrew.cmu.edu!bg0l+ From: bg0l+@andrew.cmu.edu (Bruce E. Golightly) Newsgroups: comp.databases Subject: Re: Help on Ingres "permit" statements Message-ID: Date: 24 Oct 90 12:32:45 GMT References: <1990Oct22.180038.26007@nntp-server.caltech.edu> Organization: Carnegie Mellon, Pittsburgh, PA Lines: 6 In-Reply-To: <1990Oct22.180038.26007@nntp-server.caltech.edu> This is very interesting. It implies that "copy" uses a different mechanism than "insert" and suggests that only the owner of the table can perform this action. If this is the case, then the work around would be to create a private table with the same structure, copy the data into it, then do a table to table insert to get it where you want it.