| Lists: | pgsql-jdbc |
|---|
| From: | Steven Bell <sfbell(at)keasdesign(dot)net> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Retrieving User information |
| Date: | 2004-07-13 15:42:06 |
| Message-ID: | 40F402CE.8040304@keasdesign.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-jdbc |
What is the best method to retrieve user information on a particular
database?
| 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 |
| 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