look at the documentation for WITH ADMIN and note the caveats.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Steven" <SPAMBLOCKER_at_gmx.net> wrote in message
news:b9b3hl$gv2t2$1_at_ID-82797.news.dfncis.de...
> Hi,
>
> I'm trying to determine which rights I need for a certain action and
> hopefully someone can help me with this. I am using Oracle 8.1.7
>
> Support I have a user TOM
> I login with the user FRED
> and create a table TABXX in the TOM scheme (as fred). create table
> TOM.TABXX
>
> Now as I am still logged in as FRED I want to grant ALL on the table I
just
> created (tom.tabxx) to the user JULIE.
>
> I always get an privileges error. what right does my user FRED need in
> order to grant the select rights on this table that he just created in
> someone elses scheme.
>
> know what I mean?
>
> Any help appricated.
>
> thanks,
> Steve.
>
> --
> -----------------------------------------------------------------
> Holidays in Berchtesgaden, Germany:
> http://www.sonnenkoepfl.de
> http://unterkunft-berchtesgaden.de
> http://pension-berchtesgaden.de
>
>
Received on Wed May 07 2003 - 09:11:39 CDT
