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?