Thread: [Squirrel-sql-users] Oracle plugin and schema restriction
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Mathieu M. <Max...@jc...> - 2006-06-01 16:24:09
|
The restriction established on the tree view with the last version of the Oracle plugin is too restrictive. I use a read-only schema (names XX_RO) that have only readonly access to an other schema (XX_OWN). When I connect using XX_RO, I can't visualize XX_OWN, I only have access to SYS. This occurs with Squirrel 2.2 and in the last snapshot (release 0.16 of the plugin). My XX_TO schema have only "grant-access" to XX_OWN, there is no synonym defined. Is there an option to inactivate this restriction ? Thanks for your help. Maxime Mathieu A long term SquirrelSQL happy user. |
From: Gerd W. <bir...@t-...> - 2006-06-02 04:49:36
|
Mathieu Maxime wrote: > The restriction established on the tree view with the last version of > the Oracle plugin is too restrictive. I use a read-only schema (names > XX_RO) that have only readonly access to an other schema (XX_OWN). > > When I connect using XX_RO, I can't visualize XX_OWN, I only have access > to SYS. > This occurs with Squirrel 2.2 and in the last snapshot (release 0.16 of > the plugin). My XX_TO schema have only "grant-access" to XX_OWN, there > is no synonym defined. > > Is there an option to inactivate this restriction ? Yes, there is. See menu File --> Global Preferences --> Tab: Oracle. By the way all these loading things are in development at the moment. I'm in contact with somebody who has quite a big Oracle database and has considerable startup performance problems. Some more changes will be done to solve these kind of problems. > Thanks for your help. > > Maxime Mathieu > A long term SquirrelSQL happy user. Nice to know. Thank you for using SquirrelSQL. Gerd |