Eclipse Community Forums: DTP » Connect to Schema

Help

Home

Home » Eclipse Projects » DTP » Connect to Schema

Show: Today's Messages :: Show Polls :: Message Navigator

Connect to Schema [message #31949]

Mon, 09 July 2007 17:26

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

Report message to a moderator

Re: Connect to Schema [message #33280 is a reply to message #31949]

Mon, 23 July 2007 15:16

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
>
>

Report message to a moderator

Re: Connect to Schema [message #33532 is a reply to message #31949]

Thu, 26 July 2007 23:59

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
>
>

Report message to a moderator

Re: Connect to Schema [message #586738 is a reply to message #31949]

Mon, 23 July 2007 15:16

Brian Fitzpatrick

Messages: 500
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
>
>

Report message to a moderator

Re: Connect to Schema [message #586851 is a reply to message #31949]

Thu, 26 July 2007 23:59

Anil Samuel

Messages: 108
Registered: July 2009

Senior Member

Report message to a moderator

Previous Topic:	cannot create view (DB2) -- correct SQL statement does not work
Next Topic:	"SQL Results" Tab

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 20 04:44:02 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter