How do I identify the privileges a role has?

PostgeSQL: 8.2.4

I have a database XYZ that has a user, USER1. The database XYZ has many
schemas. I have 12 different web applications that connect to the
database XYZ. My hope was to create a different "role" for each
application.

I used the command "createuser" to create USER2. When I went to use
USER2 it only has read access on the database XYZ. The user USER2 also
cannot connect to the database from a software application.

Is there an SQL command I can use that will tell me all of the
privileges allowed for USER1 so that I can then assign those same
privileges to USER2?

Thanks,

Lance Campbell

Project Manager/Software Architect

Web Services at Public Affairs

University of Illinois

217.333.0382

http://webservices.uiuc.edu