Re: can't GRANT access to another's objects as DBA - ?

In article <2584_at_grivel.une.edu.au>, janene_at_metz.une.edu.au (Janene Carey) writes:
> Hello.
>
> We're running 6.0.34 on dec risc ultrix. I needed to give Fred
> access to some tables owned by Mary. Logged in as DBA (system)
> I can see Mary's stuff, check out the data, etc, but when I say
>
> grant select on mary.table to fred
> I get *
> table or view does not exist.
>
> Does this mean that only the OWNER can grant access?

YES.
> and that the
> DBA can do everything else but?

YES.
> Seems a bit silly.

YES.
> Or is it a "feature" of the 6.0.34 release?

NO.

We reported this problem to our Oracle HOTLINE here in OZ when we first received V6.0.30. The manuals state that the DBA should be able to do it but here we are 6 bug fix releases later and it still doesn't work. Obviously not a very important feature for a DBA to have.  

We had to modify our security package to get around the problem by always using the table's owner when doing grants.

Anybody know if this is fixed in V7?

-- 

Bruce...        pihlab_at_hhcs.gov.au

"If you eat a live frog first thing in the morning ...
 Nothing worse will happen to you or the frog for the rest of the day"

*******************************************************************
* Bruce Pihlamae  --  Database Administration                     *
* Commonwealth Department of Health, Housing & Community Services *
* Canberra, Australia                             (W) 06-289-7056 *
*******************************************************************
* These are my own thoughts and opinions, few that I have.        *
*******************************************************************