Re: [GENERAL] I'm in need of something that should be there

2008-03-07 Thread Ralph Smith
SUPER Eric! Very explanatory! Thank you! Ralph Smith = On Mar 6, 2008, at 10:17 AM, Erik Jones wrote: On Mar 6, 2008, at 11:52 AM, Ralph Smith wrote: Ralph Smith wrote: And should be easier to find in the manual! I've looked in many related chapters of the 8.2

Re: [GENERAL] I'm in need of something that should be there

2008-03-06 Thread Ralph Smith
Ralph Smith wrote: And should be easier to find in the manual! I've looked in many related chapters of the 8.2 manual for a way to find out WHY a specific user has access to a database. Chapter 5Data Definition Chapter 18 Database Roles Privileges Chapter 20 Client Authorization

Re: [GENERAL] I'm in need of something that should be there

2008-03-06 Thread Richard Huxton
Ralph Smith wrote: So am I to assume that there is no way to query just what privs a user/role has on an object, anything, from a DB to an index? Well, obviously you can see what permissions an object has - \dp from psql. See the manual for details. Run psql with -E if you want to see the

Re: [GENERAL] I'm in need of something that should be there

2008-03-06 Thread Erik Jones
On Mar 6, 2008, at 11:52 AM, Ralph Smith wrote: Ralph Smith wrote: And should be easier to find in the manual! I've looked in many related chapters of the 8.2 manual for a way to find out WHY a specific user has access to a database. Chapter 5Data Definition Chapter 18 Database

Re: [GENERAL] I'm in need of something that should be there

2008-03-06 Thread John Koller
Ralph Smith wrote: Ralph Smith wrote: And should be easier to find in the manual! I've looked in many related chapters of the 8.2 manual for a way to find out WHY a specific user has access to a database. Chapter 5Data Definition Chapter 18 Database Roles Privileges

[GENERAL] I'm in need of something that should be there

2008-03-05 Thread Ralph Smith
And should be easier to find in the manual! I've looked in many related chapters of the 8.2 manual for a way to find out WHY a specific user has access to a database. Chapter 5Data Definition Chapter 18 Database Roles Privileges Chapter 20 Client Authorization postgres=# select *

Re: [GENERAL] I'm in need of something that should be there

2008-03-05 Thread John Koller
Ralph Smith wrote: And should be easier to find in the manual! I've looked in many related chapters of the 8.2 manual for a way to find out WHY a specific user has access to a database. Chapter 5Data Definition Chapter 18 Database Roles Privileges Chapter 20 Client Authorization