X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C96A5D8C50 for ; Fri, 23 Sep 2005 05:00:29 -0300 (ADT) 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 89069-03 for ; Fri, 23 Sep 2005 08:00:18 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 06E2ED89AA for ; Fri, 23 Sep 2005 05:00:19 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id j8N80HsO090676 for ; Fri, 23 Sep 2005 08:00:17 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id j8N7lHGA087648 for pgsql-admin@postgresql.org; Fri, 23 Sep 2005 07:47:17 GMT (envelope-from news) From: Hannes Dorbath X-Newsgroups: pgsql.admin Subject: Re: Hi......... Date: Fri, 23 Sep 2005 09:47:16 +0200 Organization: Hub.Org Networking Services Lines: 15 Message-ID: References: <055001c5c010$44a85760$cd00000a@amiindiahjwbgh> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Thunderbird 1.4 (Windows/20050908) In-Reply-To: <055001c5c010$44a85760$cd00000a@amiindiahjwbgh> To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=-2.465 required=5 tests=[ALL_TRUSTED=-2.82, AWL=0.355] X-Spam-Level: X-Archive-Number: 200509/264 X-Sequence-Number: 19001 On 23.09.2005 09:27, sandhya wrote: > 1) To Display all the databases under Particular user > 3) To Display the permissions of the users > 4) To Display the tables and Access permissions of it under a database start psql with -E option then type \? and choose what you need. > 2) To Display the timings of login and logout of the databases of other users. see the logging section in postgresql.conf -- Regards, Hannes Dorbath