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@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
