Postgres Pro
Downloads
Home   >   mailing lists

How do I identify the privileges a role has? - Mailing list pgsql-admin

From Campbell, Lance
Subject How do I identify the privileges a role has?
Date
Msg-id B10E6810AC2A2F4EA7550D072CDE8760197DD0@SAB-FENWICK.sab.uiuc.edu
Whole thread Raw
Responses Re: How do I identify the privileges a role has?  ("Campbell, Lance" <lance@uiuc.edu>)
List pgsql-admin
Tree view

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

 

pgsql-admin by date:

Previous
From: dx k9
Date:
Subject: jumpstart - pgsql.v824
Next
From: Tom Lane
Date:
Subject: Re: how to check objects dependency??