Received: from freebie.dcfinc.com (freebie.dcfinc.com [205.159.99.240]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fAO373m91733 for ; Fri, 23 Nov 2001 22:07:03 -0500 (EST) (envelope-from chad@eldocomp.com) Received: from paradise (cx74889-a.phnx3.az.home.com [24.1.193.157]) by freebie.dcfinc.com (8.8.7/8.8.3a) with ESMTP id UAA19295; Fri, 23 Nov 2001 20:07:01 -0700 (MST) Message-Id: <4.2.2.20011123200625.00a75740@smtp.eldocomp.com> X-Sender: clarson@smtp.eldocomp.com (Unverified) X-Mailer: QUALCOMM Windows Eudora Pro Version 4.2.2 Date: Fri, 23 Nov 2001 20:06:56 -0700 To: MG , pgsql-admin@postgresql.org From: "Chad R. Larson" Subject: Re: table permissions In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Archive-Number: 200111/125 X-Sequence-Number: 2650 At 10:39 AM 11/22/01 +0000, MG wrote: >How can I query (in SQL) the user permissions of a table? Which system table >stores the tables permissions for the user? select * from pg_user ; -crl -- Chad R. Larson (CRL22) chad@eldocomp.com Eldorado Computing, Inc. 602-604-3100 5353 North 16th Street, Suite 400 Phoenix, Arizona 85016-3228