Обсуждение: Hi.........
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
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
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