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 .
--------------------------------------------------------------------------------------- [EMAIL PROTECTED] 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 quitusps=# revoke all on database usps from public,test; REVOKE usps=# \q [EMAIL PROTECTED] 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 quitusps=> 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=>
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
