I was able to make it work by granting query rewrite and global query rewrite system priveleges to the user.

But the user had DBA rights and shouldnt that mean that he has all the system priveleges assigned by default.

Thanks
Anurag