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 442F5D7E12 for ; Fri, 23 Sep 2005 04:20:31 -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 81214-01 for ; Fri, 23 Sep 2005 07:20:26 +0000 (GMT) Received: from mars.amiindia.co.in (unknown [203.199.198.229]) by svr1.postgresql.org (Postfix) with ESMTP id 9A74BD7DE2 for ; Fri, 23 Sep 2005 04:20:19 -0300 (ADT) Received: from amiindiahjwbgh ([10.0.0.205]) (authenticated bits=0) by mars.amiindia.co.in (8.12.10/8.12.11) with ESMTP id j8N7HefT021855; Fri, 23 Sep 2005 12:47:44 +0530 Message-ID: <055001c5c010$44a85760$cd00000a@amiindiahjwbgh> From: "sandhya" To: "postgre" Cc: "sandhya" Subject: Hi......... Date: Fri, 23 Sep 2005 12:57:31 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_054D_01C5C03E.5BC63970" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.061 required=5 tests=[AWL=-0.017, FORGED_RCVD_HELO=0.05, HTML_60_70=0.027, HTML_MESSAGE=0.001] X-Spam-Level: X-Archive-Number: 200509/263 X-Sequence-Number: 19000 This is a multi-part message in MIME format. ------=_NextPart_000_054D_01C5C03E.5BC63970 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Is there any way/any SQL query of getting information regarding users. Like .... 1) To Display all the databases under Particular user 2) To Display the timings of login and logout of the databases of other = users. 3) To Display the permissions of the users 4) To Display the tables and Access permissions of it under a database Can any one please do helpful in the above cases........ Thank you -Sandhya ------=_NextPart_000_054D_01C5C03E.5BC63970 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Is there any way/any SQL query of = getting=20 information regarding users.
Like ....
1) To Display all the databases under = Particular=20 user
2) To Display the timings of login and = logout of=20 the databases of other users.
3) To Display the permissions of the=20 users
4) To Display the tables and Access = permissions of=20 it under a database
 
Can any one please do helpful in the = above=20 cases........
 
Thank you
-Sandhya
------=_NextPart_000_054D_01C5C03E.5BC63970--