If you're running 7.0, update to 7.1, you may be running
into a permissions problem on the references constraints.
On Wed, 16 May 2001, Muhammad Rusydi wrote:
> 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...