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

Is it possible that database B has some additional security features enabled?

The SQL92_SECURITY ( or maybe it's SQL_SECURITY ) is set to '=TRUE' in init.ora, then a user must have SELECT privilege before being granted INSERT, DELETE or UPDATE.

I haven't tested this, but you might want to check.

Jared Still
ValueRx/RxNet
Oracle DBA - DG/UX Sysadmin - Part Time Perl Evangelist ;) jared_at_psnw.com
stillj_at_valuerx.com Received on Tue May 13 1997 - 00:00:00 CDT