I found the proper way to deal with this situation. No response is necessary.
Thanks,
Lance Campbell
Project Manager/Software Architect
Web Services at Public Affairs
University of Illinois
217.333.0382
http://webservices.uiuc.edu
From: Campbell, Lance
Sent: Friday, November 02, 2007 9:55 AM
To: pgsql-admin@postgresql.org
Subject: 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