Charlie Toohey <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
