Re: SECURITY

> why when i create user and create database for this user, he can
> connect to my others database , (not only his own) and create there
> tables and etc.  He can not select , delete etc but he can create
> something and then drop this , is can be like a bug ?

Nope.  You need to remove access to the public schema if you want to
prevent this.

REVOKE USAGE ON SCHEMA public FROM PUBLIC;

It also might be wise for you to look at the pg_hba.conf and make use
of the samegroup directive.  -sc


PS <feature_request>It'd be really slick if there was a database,
   user, and method type that'd be pgsql or some such and would allow
   the DBA to configure what users get access to what tables _inside_
   of the database via a system catalog, leaving pg_hba.conf as an all
   else fails last resort mechanism used in recovery or
   bootstrapping.</feature_request>

--
Sean Chittenden