Re: Grant blanket permissions on a database

From: Kirk Strauser <kirk(at)nmotioninc(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Grant blanket permissions on a database
Date: 2001-12-04 20:51:37
Message-ID: 87elma909y.fsf@legion.priv
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


At 2001-12-04T20:43:26Z, Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message JStanczak 2001-12-04 20:52:02 Can PostgreSQL backup online?
Previous Message Stephan Szabo 2001-12-04 20:43:26 Re: Grant blanket permissions on a database