I'm a newbie. I'll admit it. I'm having some trouble. I have 8.1 installed on ubuntu. I have a simple database set up. I have a new user set up and I can log in as that user. I've set the owner of the simple database to that user with 'ALTER DATABASE [db] OWNER TO [user]', and this user shows up as the owner with '\l+'. Yet, I can't do anything with the database as that user. Can't even select. I added select privaledges to a table for that user, and then select worked.
However, from what I can gather from reading this...
http://www.postgresql.org/docs/8.1/interactive/privileges.html the owner should be able to do this kind of stuff without explicitly adding privs. Any idea? I assume the ORIGINAL owner has full privs, but a set owner does not. Is this correct?
If so, is there any way to set privs for a new owner without explicitly listing each table?
Thanks in advance