X-Original-To: pgsql-sql@postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 99F82925B21 for ; Wed, 28 May 2003 15:58:07 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 24734-07 for ; Wed, 28 May 2003 15:58:03 -0400 (EDT) Received: from office.affinitymark.com (adsl-67-120-121-217.dsl.snfc21.pacbell.net [67.120.121.217]) by developer.postgresql.org (Postfix) with SMTP id 06E34925AB7 for ; Wed, 28 May 2003 15:58:02 -0400 (EDT) Received: (qmail 27741 invoked from network); 28 May 2003 19:58:00 -0000 Received: from unknown (HELO there) (192.168.100.230) by slim.affinitymark.com with SMTP; 28 May 2003 19:58:00 -0000 Content-Type: text/plain; charset="iso-8859-15" From: Charlie Toohey To: pgsql-sql@postgresql.org Subject: schema-qualified permission problem Date: Wed, 28 May 2003 12:58:00 -0700 X-Mailer: KMail [version 1.3.1] MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <20030528195802.06E34925AB7@developer.postgresql.org> X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/540 X-Sequence-Number: 13705 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 List of relations Schema | Name | Type | Owner --------+------------------------+----------+-------- owneruser | users | table | owneruser ttvdev=> select count(*) from owneruser.users; count ------- 0 (1 row) ttvdev=> \dp Access privileges for database "ttvdev" Schema | Table | Access privileges --------+------------------------+--------------------------------- owneruser | users | {=,owneruser=arwdRxt,ttvuser=arwd} ttvdev=> \c - postgres Password: You are now connected as new user postgres. ttvdev=# select count(*) from owneruser.users; count ------- 0 (1 row) ttvdev=> \c - ttvuser Password: You are now connected as new user ttvuser. ttvdev=> \d owneruser.users Table "owneruser.users" Column | Type | Modifiers --------------------+-----------------------------+----------- user_id | integer | not null initials | character varying(3) | not null username | character varying(18) | not null password | character varying(25) | not null email | character varying(256) | not null authenticationdate | timestamp without time zone | creationdate | timestamp without time zone | modifydate | timestamp without time zone | userlastmodified | timestamp without time zone | adminlastmodified | timestamp without time zone | autologin | character varying(1) | active | character varying(1) | passhint | character varying(25) | firstname | character varying(40) | lastname | character varying(40) | sex | character varying(6) | department | character varying(40) | manager_flag | character varying(1) | phone | character varying(50) | Indexes: pk_users primary key btree (user_id) ttvdev=> select count(*) from owneruser.users; ERROR: owneruser: permission denied