Assumptions are bad.
Thanks for the response.
On 4/14/06, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
"Kevin Galligan" <mailinglists@xxxxxxxxxxxxx> writes:
> 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.
Ownership of a database doesn't imply much except the right to drop the
DB as a whole. In particular, it has essentially nothing to do with
privileges on pre-existing objects within the database.
> 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.
Where do you get that from? It's certainly not the intended meaning.
Perhaps what you want to do is also ALTER OWNER on each
table/function/etc within the database.
regards, tom lane
