""sandeep_c24"" <sandeep@...> wrote in message
news:a63kfa+2qqk@......

> How do I assign a new user all the
> rights the owner of database has?

You have to extract metadata and replace the owner's name by the new user.
However, the grants aren't totally equivalent: the owner has special rights
that non-owners don't have.

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