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
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?
Tad Marko <tmarko(at)metrosplash(dot)com>
pgsql-admin by date
|Next:||From: Lee Wu||Date: 2005-01-10 17:45:15|
|Subject: Vacuum full - disk space eaten by WAL logfiles|
|Previous:||From: Tom Lane||Date: 2005-01-10 02:58:06|
|Subject: Re: input in flex scanner failed |