Re: Grant Question - Mailing list pgsql-admin

From Bruno Wolff III
Subject Re: Grant Question
Date
Msg-id 20030514173535.GA3260@wolff.to
Whole thread Raw
In response to Grant Question  (Travis Whitton <whitton@atlantic.net>)
List pgsql-admin
On Mon, May 12, 2003 at 21:11:47 +0000,
  Travis Whitton <whitton@atlantic.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.

pgsql-admin by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: eRserver
Next
From: Andrew Sullivan
Date:
Subject: Re: database running slow