Re: How do I identify the privileges a role has?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxx
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

 


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux