|
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 217.333.0382 http://webservices.uiuc.edu |
