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

Re: [SPAM] Re: Permissions not working

From: Pallav Kalva <pkalva(at)deg(dot)cc>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,"scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: [SPAM] Re: Permissions not working
Date: 2004-05-03 13:33:01
Message-ID: 40964A0D.5070105@deg.cc (view raw or flat)
Thread:
Lists: pgsql-sql
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(at)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(at)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=>


In response to

Responses

pgsql-sql by date

Next:From: Tom LaneDate: 2004-05-03 14:23:23
Subject: Re: [SPAM] Re: Permissions not working
Previous:From: Paul ThomasDate: 2004-05-03 12:34:34
Subject: Re: \D TO FILE

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