""Ann W. Harrison"" <aharrison@...> wrote in message
news:5.1.0.14.2.20020327150132.044aa210@......

> At 10:23 AM 3/27/2002 +0100, Martijn Tonies wrote:
> > >
> > > You can change the owner while connected with the owner, BUT
> > > IT WON'T WORK
> > > FOR SQL/GDML RIGHTS.
> > > -- Murphy.
>
> You also need to GRANT ALL with admin and with grant on the
> table to the new owner.

"With grant option" only, because "with admin option" is for roles.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing