Re: permission errors

Noah Roberts <jik@foxinternet.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