Re: schema-qualified permission problem - Mailing list pgsql-sql

From Tom Lane
Subject Re: schema-qualified permission problem
Date
Msg-id 9237.1054165672@sss.pgh.pa.us
Whole thread Raw
In response to schema-qualified permission problem  (Charlie Toohey <ctoohey@pacbell.net>)
List pgsql-sql
Charlie Toohey <ctoohey@pacbell.net> writes:
> Why can't my primary user (ttvuser) access tables (owned by owneruser) for
> which they've been granted access?  I can describe the table, but can't
> read it.

> ttvdev=> select count(*) from owneruser.users;
> ERROR:  owneruser: permission denied

You didn't grant USAGE permission on the owneruser schema.
        regards, tom lane


pgsql-sql by date:

Previous
From: "Matthew Nuzum"
Date:
Subject: recursive srf
Next
From: "jack"
Date:
Subject: The problems about temporary tables in V7.3.2