From: | Louis Bertrand <louis(at)bertrandtech(dot)on(dot)ca> |
---|---|
To: | Karl DeBisschop <kdebisschop(at)range(dot)infoplease(dot)com> |
Cc: | grumpy(at)cyber4(dot)org, pgsql-general(at)hub(dot)org |
Subject: | Re: [GENERAL] ownership of DBs and tables? |
Date: | 2000-02-17 04:52:59 |
Message-ID: | Pine.BSO.4.20.0002162351230.20721-100000@grendel.bts |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Yeah, I've looked at the system tables but they look scary. Without proper
documentation I'm not keen on mucking around with them. I noticed pg_class
appears to have the owner of the table (relowner).
Thanks
--Louis <louis(at)bertrandtech(dot)on(dot)ca>
Louis Bertrand http://www.bertrandtech.on.ca/
Bertrand Technical Services, Bowmanville, ON, Canada
OpenBSD: Secure by default. http://www.openbsd.org/
On Wed, 16 Feb 2000, Karl DeBisschop wrote:
>
> >>Is there a way of changing the ownership of tables and even entire
> >>databases?
> >
> >Um, after the table has been created no, but you can set up users and
> >accounts, so as you, try (in ksh, not sure about others)
>
> Um, if you are a superuser:
>
> UPDATE pg_class SET relowner=<newowner> where relmane=<table>;
>
> I don't think databases have owners - or at least owner is not listed
> in the pg_database table.
>
> --
> Karl DeBisschop <kdebisschop(at)alert(dot)infoplease(dot)com>
> 617.832.0332 (Fax: 617.956.2696)
>
> Information Please - your source for FREE online reference
> http://www.infoplease.com - Your Ultimate Fact Finder
> http://kids.infoplease.com - The Great Homework Helper
>
> Netsaint Plugins Development
> http://netsaintplug.sourceforge.net
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Micheal H. | 2000-02-17 06:50:55 | Re: postgresql newsgroups |
Previous Message | Karl DeBisschop | 2000-02-17 04:25:22 | Re: [GENERAL] ownership of DBs and tables? |