Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g0GFH0V14348 for ; Wed, 16 Jan 2002 10:17:00 -0500 (EST) (envelope-from sszabo@megazone23.bigpanda.com) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 6C5ADD5F3; Wed, 16 Jan 2002 07:17:04 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 5E0405BF4; Wed, 16 Jan 2002 07:17:04 -0800 (PST) Date: Wed, 16 Jan 2002 07:17:04 -0800 (PST) From: Stephan Szabo To: Glenn MacGregor Cc: Subject: Re: limiting access to (through) views In-Reply-To: <013401c19e9c$b3d4f790$4d00a8c0@catamount> Message-ID: <20020116071522.X43837-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200201/181 X-Sequence-Number: 6267 On Wed, 16 Jan 2002, 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? > > Example: > > table1: > col1,col2,col3 > > table1 Data: > test,here,max > test1,here1,me > test2,here2,one > test3,here3,max > test4,here4,one > test5,here5,two > > table2: > username,key > > table2 Data: > user1,max > user2,one > user3,two > user4,me > > So I have these two tables, I authenticate and gain access to the db. > How do I know who I am in a query? I need to query table2 for the key > of the username I am. Then I need to query table1 for rows that col3 > matches the key I got from the previous query. > > Is this possable with a view? CURRENT_USER should give the current user name. Hmm for the above maybe... select table1.* from table1, table2 where table1.col3=table2.key and table2.username=CURRENT_USER;