Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Which rights do I need?

Re: Which rights do I need?

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 7 May 2003 15:11:39 +0100
Message-ID: <3eb9141c$0$29710$ed9e5944@reading.news.pipex.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US