Postgres Pro
Downloads
Home   >   mailing lists

Permission denied error - best way to fix? - Mailing list pgsql-general

From Mike Christensen
Subject Permission denied error - best way to fix?
Date
Msg-id AANLkTim2Xc087ADQnZsrGupyop=XQN_ZiPi5JfmCT_mw@mail.gmail.com
Whole thread Raw
Responses Re: Permission denied error - best way to fix?  (pasman pasmański <pasman.p@gmail.com>)
Re: Permission denied error - best way to fix?  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
Tree view 
Here's the error:

pg_dump: SQL command failed
pg_dump: Error message from server: ERROR:  permission denied for
relation pantryitems
pg_dump: The command was: LOCK TABLE public.pantryitems IN ACCESS SHARE MODE

Does the user need to be a superuser, or is there some way to GRANT
this permission (if possible, I don't want this user to be able to
modify the schema)..

Mike

pgsql-general by date:

Previous
From: Thom Brown
Date:
Subject: Re: Displaying text appears as hex data
Next
From: Andreas Kretschmer
Date:
Subject: Re: Displaying text appears as hex data