Connect to Schema [message #586142] |
Mon, 09 July 2007 17:26 |
Ben Messages: 46 Registered: July 2009 |
Member |
|
|
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
|
|
|
Powered by
FUDForum. Page generated in 0.03232 seconds