Re: [GENERAL] Privilege problems: access denied on select for owner?

2009-08-03 Thread Tom Lane
Nathan Jahnke writes: > 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 >

Re: [GENERAL] Privilege problems: access denied on select for owner?

2009-08-03 Thread Sam Mason
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

[GENERAL] Privilege problems: access denied on select for owner?

2009-08-03 Thread Nathan Jahnke
Hi all, Having some trouble today accessing tables in a database: sample=# \l+ List of databases Name| Owner | Encoding | Tablespace |Description ---+--+--++--- postgres | postgres | UTF8