From: Charlie Toohey <ctoohey@pacbell.net>
To: pgsql-sql@postgresql.org
Subject: schema-qualified permission problem
Date: Wed, 28 May 2003 12:58:00 -0700
Message-ID: <20030528195802.06E34925AB7@developer.postgresql.org> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ctoohey@pacbell.net
Subject: Re: schema-qualified permission problem
In-Reply-To: <20030528195802.06E34925AB7@developer.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox