Sandeep,
PLEASE do not piggyback new questions on old threads !!!!!

At 03:04 PM 05-03-02 +1300, you wrote:

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

Write a script assigning the required GRANTs to a role you have created for
the purpose. Run that script as SYSDBA or owner. Thereafter, all that's
needed is for someone with owner privileges, i.e. any user which is already
logged in under that role, is assign the new user to that role. The user
will have those privileges as long as s/he logs in using that role in the
connect string.

cheers,
Helen

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org
_______________________________________________________