X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 40CBA3A5628 for ; Fri, 3 Dec 2004 21:42:05 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 56745-04 for ; Fri, 3 Dec 2004 21:41:53 +0000 (GMT) Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by svr1.postgresql.org (Postfix) with ESMTP id C2F4F3A3F4A for ; Fri, 3 Dec 2004 21:41:53 +0000 (GMT) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.1/8.13.1) with ESMTP id iB3LfljY025266 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Fri, 3 Dec 2004 14:41:49 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.1/8.13.1) with ESMTP id iB3LfkTQ034608; Fri, 3 Dec 2004 14:41:47 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.1/8.13.1/Submit) id iB3Lfiio034607; Fri, 3 Dec 2004 14:41:44 -0700 (MST) (envelope-from mfuhr) Date: Fri, 3 Dec 2004 14:41:44 -0700 From: Michael Fuhr To: Graf =?iso-8859-1?B?TOFzemzz?= Cc: pgsql-admin@postgresql.org Subject: Re: grants Message-ID: <20041203214144.GA34549@winnie.fuhr.org> References: <41B04C92.6060601@axis.hu> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <41B04C92.6060601@axis.hu> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200412/37 X-Sequence-Number: 15623 On Fri, Dec 03, 2004 at 12:22:58PM +0100, Graf László wrote: > In wich system table, like pg_tables, are stored the the grant attributes? > I mean those attributes, what discribe the SELECT, INSERT, etc. rights of a > use (ex. postgres) for a selected table. What are you trying to do? There are different ways to get permission information, some more appropriate than others depending on your needs. To learn more see the "System Catalogs", "Information Schema", and "Access Privilege Inquiry Functions" documentation: http://www.postgresql.org/docs/7.4/static/catalogs.html http://www.postgresql.org/docs/7.4/static/information-schema.html http://www.postgresql.org/docs/7.4/static/functions-misc.html The Information Schema is available in 7.4 and later. -- Michael Fuhr http://www.fuhr.org/~mfuhr/