Postgres Pro
Downloads
Home   >   mailing lists

Thread: GRANT/REVOKE problems

GRANT/REVOKE problems

From
Marin D
Date:
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? =-

Re: [GENERAL] GRANT/REVOKE problems

From
"Jose' Soares Da Silva"
Date:
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? =-
>