Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » Connect to Schema
Connect to Schema [message #586142] Mon, 09 July 2007 17:26
Ben is currently offline BenFriend
Messages: 46
Registered: July 2009
I'm in the Data Source Explorer and I have not had any issues with
connecting to the database. I can bring it up and browse the tables and
data on the database. Howver, I want to be able to connect to a different
schema than what my username is.

Ex: UserName = BobSmith
Password = Go1Help
Schema = prodsys
Database = Dev

In the Properties Dialog I enter in the following information:
Database = Dev
URL = jdbc:oracle:thin:@
User name = BobSmith
Password = Go1Help

When I connect, I get the tables and data associated with the schema
BobSmith. However, the username is associated to a number of different
schemas. So, for example when I want to query the prodsys schema user
table using SQL Developer I would logon as BomSmith with password Go1Help
but then write the query as Select * from prodsys.user; to get the data
from the prodsys schema.

With this information, how cna I setup the Properties dialog so that it
allows me to logon using my username and password but to be pointed at the
prodsys schema?

I appreciate any help that I can get.
Previous Topic:Connect to Schema
Next Topic:Ecore & ODA
Goto Forum:

Current Time: Sun Apr 22 03:15:23 GMT 2018

Powered by FUDForum. Page generated in 0.02039 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software