Re: Problems across schema's

Hi Richard,

For some reason that is not working i have added DROP ANY TABLE to the users privileges and it still will not work.

Any other ideas?

Wayne

"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 ....
>
> Cheers
>
> Richard
>
>
Received on Thu Mar 13 2003 - 16:31:09 CST