Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Which rights do I need?
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...Received on Wed May 07 2003 - 09:11:39 CDT
> 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
>
>
![]() |
![]() |