From: | Michael(dot)L(dot)Blume(at)frb(dot)gov |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
Subject: | Database/Table Owner Question |
Date: | 2009-02-26 21:28:07 |
Message-ID: | OFE6E52B1B.95708B8B-ON85257569.0074C2FE-85257569.0075EDE1@frbog.frb.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-general |
Thank you in advance.
I realize only the superuser and table owner can change the ownership of a
table, but is there a way to modify the database owner privileges to do
the same?
Example:
userA is database owner and creates/owns 20 tables
superuser creates userB
superuser changes database owner to userB
userB cannot change userB cannot change ownership of userA_tables
I realize this was probably on purpose to set up the balance of power
between the table and database owner, but would there be a way to quickly
set the db owner's ability to change table owners in their database?
I'm hoping for a quick spot, maybe similar to the roles table, which would
require performing grants on all tables, but just updating a setting in
one place. I don't want userB to become superuser, just able to change
table owners.
Reason:
We have a lot of test databases with multiple db_owners, but very few
superusers, and table_owners switch all the time.
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2009-02-26 21:56:46 | Re: Database/Table Owner Question |
Previous Message | Tom Lane | 2009-02-26 20:50:16 | Re: BUG #4677: memory growth |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2009-02-26 21:30:37 | Re: Postgresql selecting strange index for simple query |
Previous Message | Tim Uckun | 2009-02-26 21:19:10 | Re: speaking of 8.4... |