GRANT/REVOKE problems

From: Marin D <marin(at)iclub(dot)techno-link(dot)com>
To: pgsql-general(at)postgreSQL(dot)org
Subject: GRANT/REVOKE problems
Date: 1998-05-25 12:41:21
Message-ID: Pine.LNX.3.96.980525152431.6803A-100000@server.iclub.techno-link.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jun Kuwamura 1998-05-25 14:17:03 Makefile patches in contrib directory for 6.3.2.
Previous Message Jose' Soares Da Silva 1998-05-25 10:29:17 Re: [GENERAL] Privileges