Обсуждение: Retrieving User information

Поиск
Список
Период
Сортировка

Retrieving User information

От
Steven Bell
Дата:
What is the best method to retrieve user information on a particular
database?

Re: Retrieving User information

От
Kris Jurka
Дата:

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