Received: from wolff.to (wolff.to [66.92.219.49]) by postgresql.org (8.11.3/8.11.4) with SMTP id g0GFLRV16294 for ; Wed, 16 Jan 2002 10:21:27 -0500 (EST) (envelope-from bruno@wolff.to) Received: (qmail 27077 invoked by uid 500); 16 Jan 2002 15:23:14 -0000 Date: Wed, 16 Jan 2002 09:23:14 -0600 From: Bruno Wolff III To: Glenn MacGregor Cc: pgsql-sql@postgresql.org Subject: Re: limiting access to (through) views Message-ID: <20020116152314.GA26996@wolff.to> Mail-Followup-To: Glenn MacGregor , pgsql-sql@postgresql.org References: <013401c19e9c$b3d4f790$4d00a8c0@catamount> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <013401c19e9c$b3d4f790$4d00a8c0@catamount> User-Agent: Mutt/1.3.25i X-Archive-Number: 200201/184 X-Sequence-Number: 6270 On Wed, Jan 16, 2002 at 09:47:21AM -0500, Glenn MacGregor wrote: > Hi All, > > I need to limit access to certain rows of a table. It was suggested to do this via a view, but it seems to me that I need the current username that is logged in to do this. Also I need to get info from another table inorder to make this work. Can I have multiple selects in a single view using the output of one in another? You would want to use session_user or current_user. For now these are both the same, but eventually they may not be.