Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Problems across schema's
"Richard Foote" <richard.foote_at_bigpond.com> wrote in message
news:4f%ba.2428$LT.6538_at_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 ....
>
..and as a (very heplful, but also very protective) DBA, thanks for being
very very very nice to me, but I'm sorry; I'm afraid the answer is still no.
Regards,
Paul
Received on Sat Mar 15 2003 - 14:13:16 CST