Received: from ornak.waw.pdi.net (ornak.waw.pdi.net [195.116.8.66]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eA8DRWs88923 for ; Wed, 8 Nov 2000 08:27:32 -0500 (EST) (envelope-from vincent@waw.pdi.net) Received: (from vincent@localhost) by ornak.waw.pdi.net (8.9.3/8.9.1/rchk1.20+bspm1.13+PDi2.5/W) id OAA05929 for pgsql-sql@postgresql.org; Wed, 8 Nov 2000 14:26:54 +0100 Date: Wed, 8 Nov 2000 14:26:54 +0100 From: Mateusz Mazur To: pgsql-sql@postgresql.org Subject: Table secure problem. Message-ID: <20001108142654.A5764@ornak.waw.pdi.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.1.4i X-Archive-Number: 200011/55 X-Sequence-Number: 86 Hi. (Sorry for my english -I'am not a nativ speaker) I have some problem. I show it with example: I have base names for e.g. "db". I have also user "joe" (in pg_shadow). Joe is not a superuser or somethink like that his is normal user. He connect to db. He can't do anything because I don't give him any grants, but he can create new tables. and ther is a problem. He could create table for e.g. with large object field and put there GB of data and system break down. What should I do. Joe must connect to the base because he must select some data from table but it must be all. I will be very greatfull for any sugestion. Mateusz Mazur POLAND vincent@waw.pdi.net