Re: grant all the database object automatically

From: Akbar <melinda_sayang(at)hotpop(dot)com>
To: Bruno Wolff III <bruno(at)wolff(dot)to>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: grant all the database object automatically
Date: 2005-01-21 15:08:44
Message-ID: 1106320124.10862.1.camel@tux.akbarhome
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)hotpop(dot)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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message John DeSoi 2005-01-21 15:53:11 Re: grant all the database object automatically
Previous Message Jeff Eckermann 2005-01-21 14:57:11 Re: Error Help