Re: [SQL] schema-qualified permission problem

2003-05-29 Thread Tom Lane
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

[SQL] schema-qualified permission problem

2003-05-29 Thread Charlie Toohey
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. === Here's what I'm getting: ttvdev=> \c - owneruser Password: You are now connected as new user owneruser. ttvdev=> \d