Re: Limiting user privileges - Mailing list pgsql-admin

From Tad Marko
Subject Re: Limiting user privileges
Date
Msg-id 1105475175.8275.7.camel@boojiboy.metrosplash.com
Whole thread Raw
In response to Re: Limiting user privileges  (Michael Fuhr <mike@fuhr.org>)
Responses Re: Limiting user privileges
List pgsql-admin
On Mon, 2005-01-10 at 11:31 -0700, Michael Fuhr wrote:
> On Mon, Jan 10, 2005 at 11:19:10AM -0600, Tad Marko wrote:
> ... earlier comments regarding schemas and privileges ...

Now I'm a bit closer to having things working, but I seem to be running
into another problem granting the privileges I want for a given user.

I can

GRANT ALL ON a_specific_table TO user

but I can't figure out how to simply give some privilege to a user on
all tables.

I'm pretty sure that I don't have my head wrapped around schemas well
enough, so maybe what I ought to be asking is how do I create a database
in a new schema and then use the schema to control user access???

Thanks,
Tad
--
Tad Marko <tmarko@metrosplash.com>


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Vacuum full - disk space eaten by WAL logfiles
Next
From: "BASEI, Sidnei R."
Date:
Subject: PostgreSQL Performance