Skip site navigation (1) Skip section navigation (2)

Weird Grant/Revoke/Usage behavior

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Weird Grant/Revoke/Usage behavior
Date: 2005-12-02 05:04:18
Message-ID: 438FD5D2.6070202@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Hello,

The below seems incorrect. If I am in the schema the behavior seems 
correct. I can't see or select from the table.
However if I am not in the schema I am able to see the table and its 
structure. The user jd is not a superuser.

cleancontact=# revoke usage on schema financials from jd;
REVOKE
cleancontact=# \c cleancontact jd
You are now connected to database "cleancontact" as user "jd".
cleancontact=> \d financials.foo
                          Table "financials.foo"
 Column |  Type  |                        Modifiers
--------+--------+---------------------------------------------------------
 id     | bigint | not null default nextval('financials.foo_id_seq'::text)
 fname  | text   |
Indexes:
    "foo_pkey" PRIMARY KEY, btree (id)

cleancontact=> set search_path='financials';
SET
cleancontact=> \d
No relations found.
cleancontact=> \d foo
Did not find any relation named "foo".
cleancontact=>


Responses

pgsql-hackers by date

Next:From: Joshua D. DrakeDate: 2005-12-02 05:19:10
Subject: Additional Grant/revoke problem
Previous:From: Bruce MomjianDate: 2005-12-02 04:34:00
Subject: Re: Numeric 508 datatype

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group