Skip site navigation (1) Skip section navigation (2)

Confused about rights

From: Perry The Cynic <perry(at)cynic(dot)org>
To: pgsql-novice(at)postgresql(dot)org
Subject: Confused about rights
Date: 2001-07-07 07:14:07
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

I am just starting to use postgresql (7.0.2, on Debian), and I am rather 
confused about how to use its access rights (grant/revoke). Two questions 
in particular:

(1) I created a database and table as a super-user, then started to GRANT 
away. The first thing I noticed is that UPDATE and DELETE rights are 
actually the same in postgresql - did I get that right? So I can't actually 
give the right to change anything in a table without also giving the right 
to completely erase all rows from it?

(2) The COPY command documentation says that COPY ... FROM STDIN requires 
"insert OR update" rights to the table. I tried to set up a non-privileged 
user with just INSERT rights on a table, but COPY rejects an attempt to 
COPY unless I (also, or just) grant UPDATE rights to that user. I can use 
INSERT commands just fine with just INSERT rights, but not COPY. Is that a 
feature or a bug? (It is definitely annoying - I wanted to set up a "least 
privileged" account for a web server to just dump data into the table, so 
it can't possibly change or delete anything once it's stored there.)

I tried to browse/search the mailing list archives and "interactive 
documentation", but I guess I don't know the magic keywords to look for...

  -- perry
Perry The Cynic                                             perry(at)cynic(dot)org
To a blind optimist, an optimistic realist must seem like an Accursed Cynic.


pgsql-novice by date

Next:From: bbakowskiDate: 2001-07-07 12:00:41
Subject: Postgres and Suse Linux 7.1
Previous:From: Jan WieckDate: 2001-07-06 15:00:14
Subject: Re: Cross database foreign keys

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group