Re: [ADMIN] Authentication Problems

On Fri, 31 Jul 1998, G.Elangovan wrote:

> Please suggest me what are all the way i
> can implement AUTHENTICATION on USER , DATABASE and TABLE.
> As i have seen, to my knowledge i understood we can implement
> Grant and Revoke on table
> But how can we do the same on the DATABASE
> There is a password attribute in pg_shadow
> how can this be used to implement on USER
>
>
> And finally please help to know whether Postgres 6.3.2
> has security on the USER AND DATABASE
>
> HOW CAN I CREATE pg_ident.conf and how can i use it for authentication
> on User/Database/Table

This file exists in your PGDATA directory (the one which has the data
directory holding your databases).

It's the place to restrict which client hosts can access which databases.
The default file contains instructions on how to taylor it to your needs.

As for restricting user accesses to a database, the only way for that
(AFAIK) is with grant. ie: grant priveledges to the users you want to have
access, and revoke permissions to public.

--
Peter T Mount peter(at)retep(dot)org(dot)uk or petermount(at)earthling(dot)net
Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres