From: Bruce Momjian <pgman@candle.pha.pa.us>
Message-Id: <200110181451.f9IEpKf09886@candle.pha.pa.us>
Subject: Re: docs about security
In-Reply-To: <d6351bca.0110171022.1cce600@posting.google.com>
	"from speeves at Oct 17, 2001 11:22:32 am"
To: speeves <speeves@unt.edu>
Date: Thu, 18 Oct 2001 10:51:20 -0400 (EDT)
CC: pgsql-docs@postgresql.org
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=US-ASCII

> Hi!
> 
> I am resending a plea for some good security docs, or locations
> thereof.  I have been wrestling with security on Postgres for some
> time, and have finally given up for a time.  Is there a chance that
> someone could write a good tutorial, or a chapter in a book, that can
> explain the various aspects of security on Postgres.
> 
> The reason that I am asking, is because I have been trying to see if
> Postgres would/could be a replacement for our 30+ databases(access +
> sql server).  From the understanding that I get from what I read it
> doesn't look like I can do the security scheme that I want.  (I have
> great respect for all of you who are working on a great product, but
> as of now, I can't wrap my brain around your security scheme...:(  )

Well, my book does cover it a little:
	
	http://www.postgresql.org/docs/awbook.html

There is table-level security (GRANT), view-level security, and
database/host access security.

Tell us what you want to do and we can tell you if you can do it with
PostgreSQL.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026