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