> > I'm using Firebird 1.5. I am having 2 users, Sysdba and Mauleen.
> > Mauleen is having all rights on the database tables and storedProc. I
> > had updated the rdb$elations table and set the owner as mauleen for
> > each item.
>
> Whoa, why are you directly manipulating with the system tables?
>
> Use grants to set permissions, nothing else.

Adam, do you know of any GRANT statement to change table ownership?

:-)

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com