grant user...HELP...

From: "Muhammad Rusydi" <rusydi(at)cbn(dot)net(dot)id>
To: "postgres general" <pgsql-general(at)postgresql(dot)org>
Subject: grant user...HELP...
Date: 2001-05-16 13:31:52
Message-ID: 005801c0de0c$d1c50de0$4f02a8c0@windows
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2001-05-16 13:38:34 Re: Trigger only firing once
Previous Message Artur Plawiak 2001-05-16 13:14:57 Functions in PostgreSQL under Windows