Received: from aragorn.ics.muni.cz (ns.muni.cz [147.251.4.33]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4SGEJA24020 for ; Mon, 28 May 2001 12:14:19 -0400 (EDT) (envelope-from xfinstrl@informatics.muni.cz) Received: from anxur.fi.muni.cz (12840@anxur.fi.muni.cz [147.251.48.3]) by aragorn.ics.muni.cz (8.8.5/8.8.5) with ESMTP id SAA07724; Mon, 28 May 2001 18:14:17 +0200 (MET DST) Received: (from xfinstrl@localhost) by anxur.fi.muni.cz (8.8.5/8.8.5) id SAA14265; Mon, 28 May 2001 18:14:15 +0200 (MET DST) Date: Mon, 28 May 2001 18:14:15 +0200 From: Ludek Finstrle To: "Selowa, Simon" Cc: pgsql-interfaces@postgresql.org Subject: Re: Re: ODBC Security Message-ID: <20010528181415.X29883@anxur.fi.muni.cz> References: <200105241904.VAA11336@intfwg02.sbic.co.za> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2i In-Reply-To: <200105241904.VAA11336@intfwg02.sbic.co.za>; from sselowa@mail.sbic.co.za on Thu, May 24, 2001 at 09:24:54AM +0200 X-Archive-Number: 200105/119 X-Sequence-Number: 1649 > Is it possible to set up a security or access rights for ODBC connection?. > Lately, I have experienced a problem whereby a user deleted a table from my > DB2 Database. This user accesses the database via the ODBC connection. It depends what you want. If you fill in configuration dialog for ODBC username and password then it's impossible. But you can configure ODBC without filling username an password and then user have to fill username and password to connect to postgres (only once per session) when he use ODBC connection. And in postgresql you can specify users and their privileges. Regards Luf