Re: [SPAM] Re: [SQL] Permissions not working

[Pallav Kalva]

usps=# revoke all on database usps from public,test;
   

You seem to think that that translates to revoking all privileges to
objects within the database.  It doesn't.  It only revokes privileges
directly associated with the database object, which are the rights to
create new schemas and temp tables within the database.
                        regards, tom lane
 

Hi Tom,
   I tried both database privileges and table privileges (all and 
select) it still doesnt work. Not sure
what is wrong here, I tried logging in as both postgres and usps user 
and both them doesnt work.

--------------------------------------------------------------------------------------------------------
[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 quit
usps=# revoke all privileges on citystate_alias from public,test;
REVOKE
usps=# \q
[EMAIL PROTECTED] pkalva]$ psql usps usps
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 privileges on citystate_alias from public,test;
REVOKE
usps=> revoke select on citystate_alias 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 quit
usps=> select * from citystate_alias limit 1;
detailcode | zipcode | aliasstreetpredir |     aliasstreetname      | 
aliasstre                                                                            
etsuffix | aliasstreetpostdir | streetpredir | streetname | streetsuffix 
| 
stree                                                                            
tpostdir | typecode | century | year | month | day | lownumber | 
highnumber | 
od                                                                            
doreven | 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 3: if posting/reading through Usenet, please send an appropriate
     subscribe-nomail command to [EMAIL PROTECTED] so that your
     message can get through to the mailing list cleanly