From: | Zeugswetter Andreas SARZ <Andreas(dot)Zeugswetter(at)telecom(dot)at> |
---|---|
To: | "'pgsql-hackers(at)hub(dot)org'" <pgsql-hackers(at)hub(dot)org> |
Subject: | AW: [HACKERS] Permissions on copy |
Date: | 1998-02-20 17:56:12 |
Message-ID: | 219F68D65015D011A8E000006F8590C6010A51EB@sdexcsrv1.sd.spardat.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> > On Fri, 20 Feb 1998, Bruce Momjian wrote:
> >
> > > Two things. First was a separate COPY priviledge, which I vote
> against.
> > > I see no real value to it, except to work around the problem that COPY
> > > doesn't use rules.
> >
> > Okay, I may be totally out in left field here (ie. unrelated), but
> > what stops a user from doing a 'COPY out' on a table that they don't
> have
> > SELECT privileges on? Kind of negates 'REVOKE ALL...', no?
>
> Yes I think a separate COPY permission makes no sense.
>
> > > Second, there was the idea of making copy allow a real select
> statement
> > > and not just a table name. If we do that, all goes through the
> > > executor, and you get view and rules working properly. May have some
> > > performance penalty, though it probabably will be minor.
> >
> > This sounds reasonable...
> >
>
>
Just to make you comfortable, yes I also completely agree
Andreas
From | Date | Subject | |
---|---|---|---|
Next Message | ocie | 1998-02-20 18:36:27 | Re: [HACKERS] Subselects and NOTs |
Previous Message | Zeugswetter Andreas SARZ | 1998-02-20 17:51:42 | AW: [HACKERS] triggers, views and rules (not instead) |