PostgreSQL Administration

Author

Hi.........

sandhya

2005-09-23, 3:23 am

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

Hannes Dorbath

2005-09-23, 3:23 am

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

Jim C. Nasby

2005-09-24, 8:23 pm

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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Sponsored Links