Re: Grant blanket permissions on a database - Mailing list pgsql-general

From Kirk Strauser
Subject Re: Grant blanket permissions on a database
Date
Msg-id 87elma909y.fsf@legion.priv
Whole thread Raw
In response to Re: Grant blanket permissions on a database  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
At 2001-12-04T20:43:26Z, Stephan Szabo <sszabo@megazone23.bigpanda.com> writes:

> IIRC, The pg_hba.conf gives the database level access permissions.  You
> still need to GRANT the appropriate permissions to the user (or make the
> user an superuser - in which case you probably want to make sure the user
> cannot log into other databases).

I guess I was used to the MySQL permissions scheme.  So, I've determined
that 'grant all on * to username' doesn't work.  Does that mean that I have
to iterate through each and every object in the database?
--
Kirk Strauser
Internet Software Engineer
NMotion, Inc.

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Grant blanket permissions on a database
Next
From: JStanczak@vinu.edu
Date:
Subject: Can PostgreSQL backup online?