GRANT/REVOKE problems
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? =-
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? =-
Show quoted text
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'
Import Notes
Reply to msg id not found: Pine.LNX.3.96.980525164153.1654A-100000@proxy.bazzanese.com | Resolved by subject fallback
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'
Show quoted text
Hi!
I cant make grant/revoke work...
An example
test=> \z
...
| test | |
...
test=> REVOKE ALL ON test FROM postgres;
CHANGE
test=> \zDatabase = 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 POSTGRESQLtype \? 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: testtest=> 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? =-