grant user...HELP...
От
Muhammad Rusydi
Тема
grant user...HELP...
Дата
Msg-id
005801c0de0c$d1c50de0$4f02a8c0@windows
Список
Дерево обсуждения
grant user...HELP... "Muhammad Rusydi" <rusydi@cbn.net.id>
Re: grant user...HELP... Stephan Szabo <sszabo@megazone23.bigpanda.com>
Hi, i had create tables like this: table one: create table mk ( code_mk varchar(4), nm_mk varchar(4), sks int2, primary key (code_mk)); table two: create table thn ( th_ak int2, tahun varchar(9), primary key (th_ak)); table three: create table nil ( numb varchar(8), th_ak int2 references thn (th_ak), code_mk varchar(8) references mk (code_mk), grade int2, primary key (numb,th_ak,code_mk)); then i grant my user with this command: grant select,update on nil to jhon; i want john able to select and update tuples on nil table, but when john try to select tuples nothing error, but when he try to update tuples from nil there's error that said he don't have permission on either mk or thn... i don't want to grant john on mk or thn, is there any tricks to do this? help... other questions is when we grant update on some tables why does delete also been granted? when john try to delete tuples on nil there's no error? and the references integrity on nil doesn't works? please help... TIA Didi
В списке pgsql-general по дате отправления