Re: [Squirrel-sql-users] Oracle plugin and schema restriction

[Gerd W. <bir...@t-...>]

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