Re: [GENERAL] GRANT/REVOKE problems

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? =-
>