Thread

1. GRANT/REVOKE problems

   Marin D <marin@iclub.techno-link.com> — 1998-05-25T12:41:21Z

   Hi!
   
   I cant make grant/revoke work...
   
   An example
   
   test=> \z 
   ...
   | test             |                                       |
   ...
   test=> REVOKE ALL ON test FROM postgres;
   CHANGE
   test=> \z
   
   Database    = test
    +------------------+----------------------------------------------------+
    |  Relation        |             Grant/Revoke Permissions               |
    +------------------+----------------------------------------------------+
   ...
    | test             | {"=r"}                                             |
   ...
   test=> \q
   
   [3:32pm]#su postgres
   Password:
   bash$ psql test
   Welcome to the POSTGRESQL interactive sql monitor:
     Please read the file COPYRIGHT for copyright terms of POSTGRESQL
   
      type \? for help on slash commands
      type \q to quit
      type \g or terminate with semicolon to execute query
    You are currently connected to the database: test
   
   test=> insert into test values ('wow!');
   INSERT 276704 1
   test=>
   
   
   Any hints?
   
   BTW the version is 6.2.1p6
   
   Thanx for the attention!
   
   	Marin
   
   
             -= Why do we need gates in a world without fences? =-
   
   
   

2. Re: [GENERAL] GRANT/REVOKE problems

   Marin D <marin@iclub.techno-link.com> — 1998-05-25T15:18:12Z

   It doesnt make difference for postgres user. The result is the same for
   any user...
   
   	Marin
   
   
             -= Why do we need gates in a world without fences? =-
   
   
   On Mon, 25 May 1998, Jose' Soares Da Silva wrote:
   > 
   > Do you want revoke all previleges from postgres?
   > Remember that user postgres is the super user.
   > I think you don't do that.
   >                                              Jose'
   
   
   

3. Re: [GENERAL] GRANT/REVOKE problems

   jose' soares <sferac@bo.nettuno.it> — 1998-05-25T16:43:51Z

   On Mon, 25 May 1998, Marin D wrote:
   
   Do you want revoke all previleges from postgres?
   Remember that user postgres is the super user.
   I think you don't do that.
                                                Jose'
   > 
   > Hi!
   > 
   > I cant make grant/revoke work...
   > 
   > An example
   > 
   > test=> \z 
   > ...
   > | test             |                                       |
   > ...
   > test=> REVOKE ALL ON test FROM postgres;
   > CHANGE
   > test=> \z
   > 
   > Database    = test
   >  +------------------+----------------------------------------------------+
   >  |  Relation        |             Grant/Revoke Permissions               |
   >  +------------------+----------------------------------------------------+
   > ...
   >  | test             | {"=r"}                                             |
   > ...
   > test=> \q
   > 
   > [3:32pm]#su postgres
   > Password:
   > bash$ psql test
   > Welcome to the POSTGRESQL interactive sql monitor:
   >   Please read the file COPYRIGHT for copyright terms of POSTGRESQL
   > 
   >    type \? for help on slash commands
   >    type \q to quit
   >    type \g or terminate with semicolon to execute query
   >  You are currently connected to the database: test
   > 
   > test=> insert into test values ('wow!');
   > INSERT 276704 1
   > test=>
   > 
   > 
   > Any hints?
   > 
   > BTW the version is 6.2.1p6
   > 
   > Thanx for the attention!
   > 
   > 	Marin
   > 
   > 
   >           -= Why do we need gates in a world without fences? =-
   >