Re: Retrieving User information - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Retrieving User information
Date
Msg-id Pine.BSO.4.56.0407131140580.27820@leary.csoft.net
Whole thread Raw
In response to Retrieving User information  (Steven Bell <sfbell@keasdesign.net>)
List 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

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: JDBC connection issue
Next
From: Kris Jurka
Date:
Subject: Re: Windows port installer