Database owner can't select
От | Kevin Galligan |
---|---|
Тема | Database owner can't select |
Дата | |
Msg-id | e7dad8010604141013s33b6a884r3f7e688b8723a355@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Database owner can't select
|
Список | pgsql-general |
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
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
В списке pgsql-general по дате отправления: