Re: Retrieving User information

From: Kris Jurka <books(at)ejurka(dot)com>
To: Steven Bell <sfbell(at)keasdesign(dot)net>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Retrieving User information
Date: 2004-07-13 16:44:27
Message-ID: Pine.BSO.4.56.0407131140580.27820@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Tue, 13 Jul 2004, Steven Bell wrote:

> What is the best method to retrieve user information on a particular
> database?
>

The JDBC DatabaseMetaData API has no provisions for returning a list of
users. It does have methods for permissions like getTablePrivileges, but
this isn't the same. You will likely need to issue direct sql statements
against the system catalogs. See pg_user for example.

Kris Jurka

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2004-07-13 16:55:56 Re: Windows port installer
Previous Message Kris Jurka 2004-07-13 16:40:48 Re: JDBC connection issue