Re: Grant Question

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Travis Whitton <whitton(at)atlantic(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Grant Question
Date: 2003-05-14 17:35:35
Message-ID: 20030514173535.GA3260@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Mon, May 12, 2003 at 21:11:47 +0000,
Travis Whitton <whitton(at)atlantic(dot)net> wrote:
>
> dummy=# GRANT ALL ON DATABASE dummy TO devel;
> GRANT

Granting all on a database allows the grantee to create schemas and
temporary tables in that database. It doesn't grant access to any
tables in that database. To do that you want to write a script that
does a query to get a list of table names and then issue grant
statments for those tables.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ericson Smith 2003-05-14 17:43:33 Trying to profile my function, but...
Previous Message Andrew Sullivan 2003-05-14 16:48:20 Re: eRserver