Re: Problems across schema's

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Fri, 14 Mar 2003 00:20:29 +1000
Message-ID: <4f%ba.2428$LT.6538@newsfeeds.bigpond.com>

"Wayne Hinch" <hinchy2000_at_lineone.net> wrote in message news:b4ptg4$gal$1_at_sparta.btinternet.com...
> Hi
>
> I am trying to drop and alter a table in another schema e.g. logged in as
> wayne attached to schema wayne if i try and say drop or alter a table in
> another schema say adam it will not let me do it.
>
> I have tried select any dictionary but with no avail. Do i need to use
> CREATE PUBLIC SYNONYM instead?
>
> Any help will be much appricated.
>

Hi Wayne,

You need the DROP ANY TABLE and ALTER ANY TABLE privileges.

You'll going to have to be very very very nice to your DBA ....

Cheers

Richard Received on Thu Mar 13 2003 - 08:20:29 CST