From: | "Mike G(dot)" <mike(at)thegodshalls(dot)com> |
---|---|
To: | Akbar <melinda_sayang(at)hotpop(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: grant all the database object automatically |
Date: | 2005-01-20 05:31:19 |
Message-ID: | 20050120053119.GA1433@thegodshalls.thegodshalls |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
At the moment there is no way to globally grant or revoke permissions on all objects in a database. It is on the developers todo 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
From | Date | Subject | |
---|---|---|---|
Next Message | Mike G. | 2005-01-20 05:36:14 | Re: How to "COPY schema1.table TO schema2.table" ? |
Previous Message | Michael Fuhr | 2005-01-20 02:21:08 | Re: log file |