Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » Connect to Schema
Connect to Schema [message #31949] Mon, 09 July 2007 17:26 Go to next message
Eclipse User
Originally posted by: Ben.Sisson.ccci.org

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:@1.1.1.1:1080:Dev
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.
Thanks,
Ben
Re: Connect to Schema [message #33280 is a reply to message #31949] Mon, 23 July 2007 15:16 Go to previous messageGo to next message
Eclipse User
Originally posted by: brianf.sybase.com

You should look at the Oracle thin driver's documentation to see if there's
a way to specify a different schema via the url or possibly use Oracle's
latest DTP plug-ins available at:
http://www.oracle.com/technology/tech/eclipse/dtp/files/gett ingstarted.html

"Ben" <Ben.Sisson@ccci.org> wrote in message
news:4692550530ed3bb88e07a82eb784ad7d$1@www.eclipse.org...
> 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:@1.1.1.1:1080:Dev
> 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.
> Thanks,
> Ben
>
>
Re: Connect to Schema [message #33532 is a reply to message #31949] Thu, 26 July 2007 23:59 Go to previous message
Anil Samuel is currently offline Anil Samuel
Messages: 108
Registered: July 2009
Senior Member
Ben

Try what Brian suggested; and post any issues here that you may come across.

The default connection from DSE got a schema filter to display only the
currently connected user; but you use the properties dialog to
modify/disable the filter.

Regards
anthos
Ben wrote:
> 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:@1.1.1.1:1080:Dev
> 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.
> Thanks,
> Ben
>
>
Re: Connect to Schema [message #586738 is a reply to message #31949] Mon, 23 July 2007 15:16 Go to previous message
Brian Fitzpatrick is currently offline Brian Fitzpatrick
Messages: 495
Registered: July 2009
Senior Member
You should look at the Oracle thin driver's documentation to see if there's
a way to specify a different schema via the url or possibly use Oracle's
latest DTP plug-ins available at:
http://www.oracle.com/technology/tech/eclipse/dtp/files/gett ingstarted.html

"Ben" <Ben.Sisson@ccci.org> wrote in message
news:4692550530ed3bb88e07a82eb784ad7d$1@www.eclipse.org...
> 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:@1.1.1.1:1080:Dev
> 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.
> Thanks,
> Ben
>
>
Re: Connect to Schema [message #586851 is a reply to message #31949] Thu, 26 July 2007 23:59 Go to previous message
Anil Samuel is currently offline Anil Samuel
Messages: 108
Registered: July 2009
Senior Member
Ben

Try what Brian suggested; and post any issues here that you may come across.

The default connection from DSE got a schema filter to display only the
currently connected user; but you use the properties dialog to
modify/disable the filter.

Regards
anthos
Ben wrote:
> 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:@1.1.1.1:1080:Dev
> 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.
> Thanks,
> Ben
>
>
Previous Topic:cannot create view (DB2) -- correct SQL statement does not work
Next Topic:"SQL Results" Tab
Goto Forum:
  


Current Time: Tue Oct 21 18:25:16 GMT 2014

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

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