Thread: grant user...HELP...

grant user...HELP...

From
"Muhammad Rusydi"
Date:
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






Re: grant user...HELP...

From
Stephan Szabo
Date:
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...