Re: docs about security

> 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