From: | Eugene Karpachov <jk(at)steel(dot)orel(dot)ru> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | grant select,update - bug or feature? |
Date: | 2000-05-29 11:19:09 |
Message-ID: | 20000529151909.A10272@steel.orel.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
Excuse me for my bad English.
Let us create test database as superuser:
create table master ( i integer primary key, a text);
-- I want to protect this table from updating by 'dbuser'
create table slave ( j integer references master, b text);
-- I want to enable updating this table by 'dbuser'
grant select on master to dbuser;
grant select,update on slave to dbuser;
-- populating tables with sample values:
insert into master (i,a) values (1,'one');
insert into master (i,a) values (2,'two');
insert into slave (j,b) values (1,'ONE');
By now, all is ok.
Then, running psql as 'dbuser':
jk=> update slave set b='four';
ERROR: master: Permission denied.
Why dbuser need 'update' permissions on 'master' table? I only want to
update 'slave' table.
If superuser grants update on master to dbuser, all works.
--
jk
From | Date | Subject | |
---|---|---|---|
Next Message | Werner Modenbach | 2000-05-29 11:23:35 | pg_dumpall: Message "failed sanity check, type with oid 155265 not found" |
Previous Message | R D | 2000-05-29 09:17:32 | few securiry questions |
From | Date | Subject | |
---|---|---|---|
Next Message | Gunnar R|nning | 2000-05-29 11:31:34 | Anonymous CVS fails |
Previous Message | Stuart Grimshaw | 2000-05-29 10:04:36 | ODBC |