| From: | "Jim Cser" <Cser(at)metro(dot)dst(dot)or(dot)us> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Granting COPY FROM access |
| Date: | 2006-07-06 01:12:31 |
| Message-ID: | s4ac0128.061@metro.dst.or.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
[post header corrected, sorry]
I have an application that uses ODBC to access a PostGreSQL 8.0.3
database. To load in text files (comma separated, with column headers),
I use the SQL statement COPY FROM, which requires me to be a superuser.
I don't need full superuser access, so I would like to restrict the
permissions to only those necessary. The GRANT doc says that INSERT
privilege allows COPY FROM, so as a superuser I did something like
"GRANT INSERT ON my_database TO regular_user".
Unfortunately, when I login to my_database as regular_user, I don't
have permission to do COPY FROM. So, my question is: can COPY FROM
permission be granted to a non-superuser, or is there something else
that I missed?
-Jim Cser
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris | 2006-07-06 02:28:14 | Re: basic log question |
| Previous Message | Jim Cser | 2006-07-06 01:08:01 | Granting COPY TO access |