Skip site navigation (1) Skip section navigation (2)

Re: Help with a query

From: "Bas Scheffers" <bas(at)scheffers(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Help with a query
Date: 2004-02-27 12:29:18
Message-ID: 4542.217.205.40.94.1077884958.squirrel@io.scheffers.net (view raw or flat)
Thread:
Lists: pgsql-general
Klint,

> select groname from pg_group
> where (select usesyside from pg_shadow where usename = 'postgres') =
> any(grolist);
Unless you are lgged in as superuser (and applications other than pgAdmin
et al shouldn't be) you will get access denied on pg_shadow. (because it
contains passwords) Selecting on pg_user gives you the same result and can
be done by any user.

Bas.

pgsql-general by date

Next:From: Shridhar DaithankarDate: 2004-02-27 12:32:30
Subject: Re: PostgreSQL insert speed tests
Previous:From: cnliouDate: 2004-02-27 12:27:36
Subject: Re: Case of strings

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group