I'm not sure what DoDo means by his last posting, so let me clarify:

I don't have a machine with 8i or 9i client. However, I can verify that DoDo's behavior (in his first post) is completely reproducible via 10gR2 client libraries as well.

So for 10gR2, it's not a library issue. It's a vanilla RDBMS privileges issue.