On Thursday, March 15, 2012 6:58:01 PM UTC-5, Christian MICHON wrote: > > Hi, > > I've a db at work (Oracle 11g) which I can access using > jdbc:oracle:thin. I verified using the same jdbc driver and > dbvisualizer that I can connect to it and see some content in several > table schemas. > > Yet, when using sequel (the gem and the binary), I point to the > default schema of my oracle login, and I seem unable to set > default_schema on Sequel.connect(). My DB.tables remains empty []. > > 1/ how can I list using sequel the list of table schemas ? ie the > containers containing tables and views (these can be very specific and > not shared among oracle logins). I may have a wrong name issue, if I > could see all possible table schemas, this could help. > > 2/ how to set it properly ? are there other commands to use than > default_schema ? > > Thanks in advance. > > -- > Christian > Christian,
It has been a long time since I used Oracle. When faced with this issue we adopted the solution described here http://www.oracle-base.com/articles/misc/SchemaOwnersAndApplicationUsers.php Might be something to consider if you want more granular control. Rohit -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To view this discussion on the web visit https://groups.google.com/d/msg/sequel-talk/-/5gW8kxF2iGUJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
