Re: grant all the database object automatically - Mailing list pgsql-novice

From Akbar
Subject Re: grant all the database object automatically
Date
Msg-id 1106320124.10862.1.camel@tux.akbarhome
Whole thread Raw
In response to Re: grant all the database object automatically  (Bruno Wolff III <bruno@wolff.to>)
Responses Re: grant all the database object automatically
Re: grant all the database object automatically
List pgsql-novice
I am sorry... but could you give me a link about that? tutorial writing
script to list all the objects from database....

Thank you.

On Thu, 2005-01-20 at 18:22 -0600, Bruno Wolff III wrote:
> On Thu, Jan 20, 2005 at 17:11:16 +0700,
>   Akbar <melinda_sayang@hotpop.com> wrote:
> >
> > 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?
>
> There isn't one now, but it isn't too hard to write scripts that query
> the database to get a list of objects and than issue corresponding
> GRANT or REVOKE commands.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org



pgsql-novice by date:

Previous
From: John DeSoi
Date:
Subject: Re:
Next
From: "Shaun McGuile"
Date:
Subject: Re: Windows 2000 Pro Error on Install