Postgres Pro
Downloads
Home   >   mailing lists

Re: Change onership of database and all tables? (fwd) - Mailing list pgsql-general

From Russ Schneider
Subject Re: Change onership of database and all tables? (fwd)
Date
Msg-id Pine.LNX.4.50.0312282050340.11630-100000@dell.sugapablo.net
Whole thread Raw
Responses Re: Change onership of database and all tables? (fwd)  (Bruno Wolff III <bruno@wolff.to>)
Re: Change onership of database and all tables? (fwd)  ("John Sidney-Woollett" <johnsw@wardbrook.com>)
List pgsql-general
Tree view 
On Sun, 28 Dec 2003, Russ Schneider wrote:

>
> In 7.2, how would you change ownership of a database and all its tables
> and sequences?
>
> Right now everything is owned by postgres and I want to change ownership
> to a regualar user.

Or if no one can answer the above question, what about a way to grant
permissions on more than one table at a time?  Like GRANT ALL PRIVILEGES
ON [ALL TABLES] TO [USER]?

--
[ Russ Schneider (a.k.a. Sugapablo)     ]
[ http://www.sugapablo.com <--music     ]
[ http://www.sugapablo.net <--personal  ]
[ sugapablo@12jabber.com   <--jabber IM ]

pgsql-general by date:

Previous
From: Casey Allen Shobe
Date:
Subject: Re: Is my MySQL Gaining ?
Next
From: "D. Dante Lorenso"
Date:
Subject: Re: simple auto-updating timestamp ?