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
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 Databa
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 Dat
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 SQL
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 Autho
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 Auth