Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: oddity with rights !?
kasperle_at_cs.tu-berlin.de wrote:
>
> Hi!
>
> I just came across an oddity when using db links.
> A has the right to just INSERT a table, no SELECT.
> He can't issue SELECT or DESC but he can INSERT (as expected).
> B (living in a distant database) creates a link to A's base,
> with A's rights.
> I would expect B to have the same rights as A.
> But B can't INSERT.
> Only if I grant SELECT to A, B can do DESC and SELECT and INSERT.
> But without SELECT there's no INSERT.
>
> Looks quite odd to me.
> Some comments? Did I do something wrong?
>
> tia,
> regards,
> Kathrin
Sorry, I forgot:
Oracle 7.0.16.4.0 on Sun connecting through sql net 1 to Oracle 7.1.6.2.0 on Sequent
regards,
Kathrin
Received on Wed May 07 1997 - 00:00:00 CDT