This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 150453 - Cross schema browsing
Summary: Cross schema browsing
Status: RESOLVED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: DB schema (show other bugs)
Version: 6.x
Hardware: All All
: P3 blocker (vote)
Assignee: Jiri Rechtacek
URL: http://nnbs.blogspot.com
Keywords:
Depends on:
Blocks:
 
Reported: 2008-10-16 23:35 UTC by hat27533
Modified: 2012-08-10 19:39 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Exception Reporter:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description hat27533 2008-10-16 23:35:30 UTC 
It would be really useful to be able to query data in schemas that the schema you are logged into has grants on via the 
database browser in netbeans.

For example :-

Logged in to a database with "thisSchema" with view/execute grants to "thatSchema"

run this sql statement:-
select emp.first_name, emp.last_name, job.title from thisSchema.employees emp, thatSchema.jobs job where emp.jobRef = 
job.jobRef

or list the schemas and objects in the database browser pane.
Comment 1 Jiri Rechtacek 2009-10-16 14:14:14 UTC 
Reassigned to new owner.
Comment 2 matthias42 2012-08-10 19:39:24 UTC 
I regularly use this (7.0-7.2) - the explorer show the other schemas and allows browsing them and the SQL editor allows cross schema queries (which are also automaticly completed)