Skip site navigation (1) Skip section navigation (2)

Re: Hi.........

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: sandhya <sandhyar(at)amiindia(dot)co(dot)in>
Cc: postgre <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Hi.........
Date: 2005-09-24 21:01:01
Message-ID: 20050924210100.GM7630@pervasive.com (view raw or flat)
Thread:
Lists: pgsql-admin
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(at)pervasive(dot)com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

In response to

pgsql-admin by date

Next:From: Guilherme AlbertoDate: 2005-09-25 15:30:53
Subject: PostgreSQL Remote Connection
Previous:From: Tom LaneDate: 2005-09-24 16:21:38
Subject: Re: could not create IPv6 socket !

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group