Re: schema-qualified permission problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Charlie Toohey <ctoohey(at)pacbell(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: schema-qualified permission problem
Date: 2003-05-28 23:47:52
Message-ID: 9237.1054165672@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Charlie Toohey <ctoohey(at)pacbell(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message jack 2003-05-29 00:17:56 The problems about temporary tables in V7.3.2
Previous Message Matthew Nuzum 2003-05-28 21:30:01 recursive srf