From: | "Kevin Galligan" <mailinglists(at)kgalligan(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Database owner can't select |
Date: | 2006-04-14 17:13:28 |
Message-ID: | e7dad8010604141013s33b6a884r3f7e688b8723a355@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm a newbie. I'll admit it. I'm having some trouble. I have
8.1installed 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
From | Date | Subject | |
---|---|---|---|
Next Message | Balazs.Klein | 2006-04-14 17:15:57 | Re: ilike and utf-8 |
Previous Message | Raphael Bauduin | 2006-04-14 17:01:04 | Re: ilike and utf-8 |