Re: Privilege problems: access denied on select for owner? - Mailing list pgsql-general

On Mon, Aug 03, 2009 at 01:39:08PM -0500, Nathan Jahnke wrote:
> So the role "sample" owns the database "sample" and has default
> privileges on the table "users" in that database. From the manual:
>
> "There is no need to grant privileges to the owner of an object
> (usually the user that created it), as the owner has all privileges by
> default."

I think all those owners are different because the user that creates
an object is its owner.  So if your users table wasn't created by your
sample user then it won't have permissions to access it.

You probably need to do:

  ALTER TABLE users OWNER TO sample;

--
  Sam  http://samason.me.uk/