Re: SECURITY - Mailing list pgsql-admin

From A.Bhuvaneswaran
Subject Re: SECURITY
Date
Msg-id Pine.LNX.4.44.0305221237090.2303-100000@Bhuvan.bksys.co.in
Whole thread Raw
In response to SECURITY  (ivan <ivan@psycho.pl>)
List pgsql-admin
> 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 ?

It need not be a bug. As and when you create a database, you are able to
revoke permissions to the database from other users. If you do that, no
other users would be able to access the database. Refer REVOKE command for
details.

regards,
bhuvaneswaran



pgsql-admin by date:

Previous
From: Robert.Farrugia@go.com.mt
Date:
Subject: Re: After VACUUM, statistics become skewed
Next
From: Tom Lane
Date:
Subject: Re: Full vacuuming of BIG tables takes too long