Re: Limiting user privileges

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>