Re: [BUGS] BUG #1222: database owner should have implicit control

#1

On Tue, 2004-08-17 at 15:02, Tom Lane wrote:

Quote:

"PostgreSQL Bugs List" <pgsql-bugs (AT) postgresql (DOT) org> writes:
Database owner should have implicit control over public schema

There has been some discussion of causing the public schema to be owned
by the DB owner, but this has not happened yet, partly because we are
not sure of all the consequences.

was just looking at this this morning. is there anyway to change
ownership of a schema? i couldn't find one and thought i'd ask before
whacking on the system tables.

Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

#2

Quote:

Database owner should have implicit control over public schema

There has been some discussion of causing the public schema to be owned
by the DB owner, but this has not happened yet, partly because we are
not sure of all the consequences.

was just looking at this this morning. is there anyway to change
ownership of a schema? i couldn't find one and thought i'd ask before
whacking on the system tables.

"ALTER SCHEMA foo OWNER TO bla" if you're a super user.

--
Fabien Coelho - coelho (AT) cri (DOT) ensmp.fr

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

#3

On Wed, 2004-08-18 at 08:57, Fabien COELHO wrote:

Quote:

Database owner should have implicit control over public schema

There has been some discussion of causing the public schema to be owned
by the DB owner, but this has not happened yet, partly because we are
not sure of all the consequences.

was just looking at this this morning. is there anyway to change
ownership of a schema? i couldn't find one and thought i'd ask before
whacking on the system tables.

"ALTER SCHEMA foo OWNER TO bla" if you're a super user.

And using 8.0... I saw that but was looking for a 7.4 solution...

Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

#4

Quote:

"ALTER SCHEMA foo OWNER TO bla" if you're a super user.

And using 8.0... I saw that but was looking for a 7.4 solution...

Maybe: UPDATE pg_namespace SET nspowner=<bla-number> WHERE nspname='foo';

--
Fabien Coelho - coelho (AT) cri (DOT) ensmp.fr

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [BUGS] BUG #1222: database owner should have implicit control

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] BUG #1222: database owner should have implicit control - 08-18-2004 , 07:31 AM

Re: [BUGS] BUG #1222: database owner should have implicit control - 08-18-2004 , 07:59 AM

Re: [BUGS] BUG #1222: database owner should have implicit control - 08-18-2004 , 02:52 PM

Re: [BUGS] BUG #1222: database owner should have implicit control - 08-19-2004 , 02:44 AM