Received: from mailgw02.execpc.com (mailgw02.execpc.com [169.207.3.78]) by hub.org (8.9.1/8.9.1) with ESMTP id OAA14667 for ; Sat, 16 Jan 1999 14:24:28 -0500 (EST) (envelope-from trowbrid@execpc.com) Received: from earth.execpc.com (trowbrid@earth.execpc.com [169.207.16.1]) by mailgw02.execpc.com (8.9.0) id NAA17852 for ; Sat, 16 Jan 1999 13:24:24 -0600 (CST) Received: (from trowbrid@localhost) by earth.execpc.com (8.9.0) id NAA23658 for pgsql-sql@postgresql.org; Sat, 16 Jan 1999 13:24:22 -0600 (CST) Message-Id: <199901161924.NAA23658@earth.execpc.com> Subject: Re: [SQL] Viewing access privileges To: pgsql-sql@postgresql.org Date: Sat, 16 Jan 1999 13:24:22 -0600 (CST) From: "Tim J Trowbridge" In-Reply-To: <199901160900.TAA32156@mustang.sdc.com.au> from "Stephen Davies" at Jan 16, 99 07:30:57 pm reply-to: trowbrid@writeme.com from: trowbrid@writeme.com X-Mailer: ELM [version 2.4 PL25-execpc] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Stephen Davies wrote: > > How can one view all of the access privileges of one or more users? > > That is, how can I check what I have GRANTed to whom? Try this: SELECT relname,relacl FROM pg_class WHERE relname !~ '^pg_'; -- Tim J Trowbridge trowbrid@writeme.com Interested in my genealogy? http://www.execpc.com/~trowbrid