# Oci8 roles and permissions

**URL:** <https://www.ruby-forum.com/t/oci8-roles-and-permissions/119439>\
**Category:** Ruby\
**Created:** [November 7, 2007, 12:46am UTC](https://www.ruby-forum.com/t/oci8-roles-and-permissions/119439 "2007-11-07T00:46:31Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sean\_n](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/858c86/32.png) [@sean\_n](https://www.ruby-forum.com/u/sean_n)\
**Post date:** [November 7, 2007, 12:46am UTC](https://www.ruby-forum.com/t/oci8-roles-and-permissions/119439/1 "2007-11-07T00:46:31Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![sean\_n](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/858c86/32.png) [@sean\_n](https://www.ruby-forum.com/u/sean_n)\
**Post date:** [November 28, 2007, 4:31am UTC](https://www.ruby-forum.com/t/oci8-roles-and-permissions/119439/2 "2007-11-28T04:31:53Z")

</div>

Hi Sean,

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