From: Tad Marko <tmarko@metrosplash.com>
To: pgsql-admin@postgresql.org
Subject: Limiting user privileges
Date: Mon, 10 Jan 2005 11:19:10 -0600
Message-ID: <1105377550.11245.0.camel@boojiboy.metrosplash.com> (raw)
Howdy!
I'm coming to postgresql from mysql, so I have a few preconceived
notions that are causing me some trouble. Specifically, I'm trying to
create users that have limited privileges on one database. It appears
that by default, a new user has a lot of privileges all over all the
databases.
1) How can I remove all privileges from all databases for a given user?
2) If I put back insert, delete and table creation privileges only on
one database for a given user, will that user magically have all sorts
of privileges on any databases that are created after doing #1 above?
Thanks,
Tad
--
Tad Marko <tmarko@metrosplash.com>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: tmarko@metrosplash.com
Subject: Re: Limiting user privileges
In-Reply-To: <1105377550.11245.0.camel@boojiboy.metrosplash.com>
References: <1105377550.11245.0.camel@boojiboy.metrosplash.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox