listing users and their rights

From: "Thomas T(dot) Thai" <tom(at)minnesota(dot)com>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: listing users and their rights
Date: 2000-12-29 23:14:50
Message-ID: Pine.NEB.4.21.0012291710370.20934-100000@ns01.minnesota.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

as a pgsql superuser, how can i list all the users and their rights? on
mysql i just do a select on the mysql table. i'm a newbie here. i read the
documents and didn't find the answer.

also, when i start 'psql' as system user joe, it says:

psql: FATAL 1: Database "joe" does not exist in the system catalog.

if i run psql as system user XXX it would say '... Database "XXX" does not
exist...'

from the documents, it seems as though i can start psql without specifying
a database.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message The Hermit Hacker 2000-12-29 23:24:22 Re: How passwords can be crypted in postgres?
Previous Message Stephan Szabo 2000-12-29 23:10:19 Re: NULLS and <> : Discrepancies ?