| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Noah Roberts <jik(at)foxinternet(dot)net> |
| Cc: | psql <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: permission errors |
| Date: | 2001-08-13 18:30:49 |
| Message-ID: | 25369.997727449@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Noah Roberts <jik(at)foxinternet(dot)net> writes:
> Oddity 2 - I created these tables as masks_adm.....as you can see below
> that is the owner....yet I frequently got permission denied errors when
> I tried to do things to these tables and had to actuall grant myself
> permission to access them.
This is a known bug in GRANT in current releases: the first explicit
GRANT on a table loses the all-rights-granted-to-table-owner default
permissions for the table. It's fixed for 7.2, but at the moment you
have to remember to grant yourself access rights too.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Noah Roberts | 2001-08-13 19:40:54 | Re: permission errors |
| Previous Message | Noah Roberts | 2001-08-13 17:26:20 | permission errors |