X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id F27C99DC891 for ; Sun, 26 Mar 2006 19:10:06 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 02636-10 for ; Sun, 26 Mar 2006 19:10:08 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id AD70D9DCB32 for ; Sun, 26 Mar 2006 19:10:03 -0400 (AST) Received: (qmail invoked by alias); 26 Mar 2006 23:10:05 -0000 Received: from dslb-084-063-016-172.pools.arcor-ip.net (EHLO colt.pezone.net) [84.63.16.172] by mail.gmx.net (mp040) with SMTP; 27 Mar 2006 01:10:05 +0200 X-Authenticated: #495269 From: Peter Eisentraut To: pgsql-admin@postgresql.org Subject: Re: Table permissions Date: Mon, 27 Mar 2006 01:10:04 +0200 User-Agent: KMail/1.8.3 Cc: Milen Dzhumerov References: <4426FAEB.6030205@gmail.com> In-Reply-To: <4426FAEB.6030205@gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200603270110.04407.peter_e@gmx.net> X-Y-GMX-Trusted: 0 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.128 required=5 tests=[AWL=0.128] X-Spam-Score: 0.128 X-Spam-Level: X-Archive-Number: 200603/278 X-Sequence-Number: 21035 Milen Dzhumerov wrote: > Unfortunately if I try to submit it, it gives me some > error. You need to post your exact input and the exact output. Otherwise we're just guessing. > My other > question is who has access to the pg_catalog.* tables? Everybody. > And are these tables per database > or shared across PgSQL? Most of them are per database, only a few of them are shared. > Is is true that every user can check if > he/she has access to a particular table and examine the ACL string? Yes. > And how can I determine if a user can change permissions for other > users? You can check the grant options available to the user. -- Peter Eisentraut http://developer.postgresql.org/~petere/