| From: | Louis Bertrand <louis(at)bertrandtech(dot)on(dot)ca> |
|---|---|
| To: | pgsql-general(at)hub(dot)org |
| Subject: | ownership of DBs and tables? |
| Date: | 2000-02-17 02:58:15 |
| Message-ID: | Pine.BSO.4.20.0002162149570.20721-100000@grendel.bts |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Is there a way of changing the ownership of tables and even entire
databases?
Here's why I ask. I created a database "webdb" for a PHP3 application and
created a database user "www" to own it. However, I am creating the actual
tables as user "louis" who has superuser privileges in PostgreSQL. When
I look at the ownership of a new table, it's "louis", not "www". I'm
doing this with psql and pgaccess. I'd rather not have to su(8) as
"www" to perform DB maintenance.
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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim Richards | 2000-02-17 03:19:39 | Re: [GENERAL] ownership of DBs and tables? |
| Previous Message | kaiq | 2000-02-16 21:55:01 | how to remove \n within a field and copy should be flexible |