Re: [Squirrel-sql-develop] Oracle plugin

[Maury H. <ml1...@sh...>]

Alexander Buloichik wrote:
> Hi, All !
> 
>   I commited patch for oracle plugin to sourceforge.
>   It detects how we connected to Oracle(as SYSTEM or ordinarily user) and
> display INSTANES and SESSIONS nodes only for SYSTEM
> user, because only SYSTEM user can read this data from
> server. Also it change display mode for USERS node. It
> displays only current user for ordinarily user, and all
> users for SYSTEM user.

I don't know about anyone else, but I don't think this is a good 'fix'. 
  SYSTEM is not the only user that can see that information.  On the 
sites where I have worked with Oracle, SYSTEM is not routinely used as a 
login from remote tools -- in fact, it has been discouraged.

I would suggest that this be changed to look to see if the user has the 
DBA role (and/or whatever other privileges are required to see that 
information) before removing it from the view.


Maury...