From: | "Campbell, Lance" <lance(at)uiuc(dot)edu> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: How do I identify the privileges a role has? |
Date: | 2007-11-02 16:40:42 |
Message-ID: | B10E6810AC2A2F4EA7550D072CDE8760197DD2@SAB-FENWICK.sab.uiuc.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
________________________________
From: Campbell, Lance
Sent: Friday, November 02, 2007 9:55 AM
To: pgsql-admin(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2007-11-02 19:30:52 | Re: how to check objects dependency?? |
Previous Message | Tom Lane | 2007-11-02 15:26:50 | Re: pg_stat_all_indexes |