From: Pallav Kalva <pkalva@deg.cc>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: scott.marlowe <scott.marlowe@ihs.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: [SPAM] Re: Permissions not working
Date: Mon, 03 May 2004 09:33:01 -0400
Message-ID: <40964A0D.5070105@deg.cc> (raw)
In-Reply-To: <200405012313.45607.peter_e@gmx.net>
References: <Pine.LNX.4.33.0404291522430.10983-100000@css120.ihs.com>
<26201.1083341979@sss.pgh.pa.us>
<40929453.10501@deg.cc>
<200405012313.45607.peter_e@gmx.net>
Peter Eisentraut wrote:
>Pallav Kalva wrote:
>
>
>>Also here is the privileges information from information_schema
>>tables. Is there a way to REVOKE these
>>privileges ?
>>
>>
>
>You need to log in as the user that has granted the privilege you want
>to revoke. In this case, log in as postgres and do REVOKE ALL FROM
>PUBLIC;.
>
>
>
I did the same, still doesnt work . Here is the sequence of what I did .
---------------------------------------------------------------------------------------
[pkalva@timmy pkalva]$ psql usps postgres
Welcome to psql 7.4.2, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
usps=# revoke all on database usps from public,test;
REVOKE
usps=# \q
[pkalva@timmy pkalva]$ psql usps test
Welcome to psql 7.4.2, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
usps=> select * from citystate_alias limit 1;
detailcode | zipcode | aliasstreetpredir | aliasstreetname |
aliasstreetsuffix | aliasstreetpostdir | streetpredir | streetname |
streetsuffix | streetpostdir | typecode | century | year | month | day |
lownumber | highnumber | oddoreven | filler | entrydate
------------+---------+-------------------+--------------------------+-------------------+--------------------+--------------+------------+--------------+---------------+----------+---------+------+-------+-----+-----------+------------+-----------+--------+-------------------------------
A | 00501 | | INTERNAL REVENUE SERVICE
| | | | WAVERLY |
AVE | | O | 19 | 94 | 05 | 01
| | | | | 2004-04-22
14:51:45.497651-04
(1 row)
usps=>
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: pkalva@deg.cc, peter_e@gmx.net, tgl@sss.pgh.pa.us, scott.marlowe@ihs.com
Subject: Re: [SPAM] Re: Permissions not working
In-Reply-To: <40964A0D.5070105@deg.cc>
* 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