I'm not that knowlegeable in Oracle roles and permissions. I just know
that when I use a certain Oracle account, I have read access to the data
through toad. But when I use the same account using a script
(ruby / oci8), I can't view any data. I have to use a more powerful
Oracle account that has more permissions. I want to use an account that only
has read-access to the database in my scripts. Any suggestions? What
should I check?

Hi Sean,

How is sql like in your ruby script and what's execution output?