At the moment there is no way to globally grant or revoke permissions on all objects in a database. It is on the
developerstodo list.
On Thu, Jan 20, 2005 at 05:11:16PM +0700, Akbar wrote:
> How do I give all database object to another user so that user can do
> everything he wants?
>
> ALTER DATABASE blabla OWNER TO another_user;
> does not give what I want because that another user
> still does not have right to manipulate table inside
> database.
>
> Since there is no ALTER TABLE * blabla command ( see the * / wild card
> sign ), I alter table one by one so that another user can do some
> operation on those table.....
> Is there any easier way to do this.....?
>
> Ok, after this, what should I do to give database objects fully to
> another user beside tables?? Should I alter function, view??? Is there
> any tool or command to give all database objects to another user
> automatically?
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster