Thread: Retrieving User information

Retrieving User information

From
Steven Bell
Date:
What is the best method to retrieve user information on a particular
database?

Re: Retrieving User information

From
Kris Jurka
Date:

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