Re: Determine users and roles

From: Jorge Godoy <jgodoy(at)gmail(dot)com>
To: RPK <rpk(dot)general(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Determine users and roles
Date: 2007-03-08 21:08:10
Message-ID: 87vehbbg05.fsf@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

RPK <rpk(dot)general(at)gmail(dot)com> writes:

> I want to determine the usernames, privileges and roles of the users that are
> created for a particular database. I am using PGSQL 8.2.3 on Windows XP. I
> want to run SQL query for this.

In PostgreSQL users aren't created per database but per cluster.

Run the equivalent of "psql -E" in your command prompt and issue a "\du".

Be seeing you,
--
Jorge Godoy <jgodoy(at)gmail(dot)com>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ted Byers 2007-03-08 21:21:32 Re: security permissions for functions
Previous Message Jorge Godoy 2007-03-08 21:02:53 Re: No buffer space available