From: Jim C. Nasby <jnasby@pervasive.com>
To: sandhya <sandhyar@amiindia.co.in>
Cc: postgre <pgsql-admin@postgresql.org>
Subject: Re: Hi.........
Date: Sat, 24 Sep 2005 16:01:01 -0500
Message-ID: <20050924210100.GM7630@pervasive.com> (raw)
In-Reply-To: <055001c5c010$44a85760$cd00000a@amiindiahjwbgh>
References: <055001c5c010$44a85760$cd00000a@amiindiahjwbgh>
Take a look at http://pgfoundry.org/projects/newsysviews/
On Fri, Sep 23, 2005 at 12:57:31PM +0530, sandhya wrote:
> 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
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jnasby@pervasive.com, sandhyar@amiindia.co.in
Subject: Re: Hi.........
In-Reply-To: <20050924210100.GM7630@pervasive.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox