oracle schema name in the connection string

I am connecting to an Oracle database. In order to target the schema associated with the database I am having to specify the database name (as the user id)  in the connection string as well as the password.

Is there anyway to specify the schema name without specifying the password?

Example : SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort))(CONNECT_DATA=(SERVICE_NAME=MyOracleSID)));
uid=DatabaseName;pwd=myPassword;
LVL 2
brgdotnetcontractorAsked:
Who is Participating?
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
To connect to the database you need a password.

You "can" set up OS authentication to connect to the database as the OS user but that opens up security problems.

You can also set up authentication via LDAP/Active Directory or a few other methods if you wish.  BUT, you must authenticate in some way.
0
 
Mark GeerlingsConnect With a Mentor Database AdministratorCommented:
This portion of the example looks incorrect to me:

uid=DatabaseName;

I would say that should be:
uid=UserName;

or:
uid=SchemaName;

If you have SQL Server experience, maybe you use the word "database" with the meaning it can have in the SQL Server world (where it means something more like the word "schema" in Oracle).

And as slightwv indicated, in Oracle, to connect to the "database" (which in Oracle means to the entire system) you have to provide a username *AND* a password one way or another.  After you log in, that doesn't mean you can see or change things in the entire system.  You will only have access to those parts of the system/database that your Oracle username allows you to see and/or work in.
0
 
Geert GConnect With a Mentor Oracle dbaCommented:
in a development environment ...
read the connection string and if the password is not supplied, ask the user for it
paste that into the in-memory connection string and use this new connectionstring to login to the oracle

can you login to oracle without a password,
well yes, single sign on, ... but it requires a lot more work than just supplying the password
https://www.oracle.com/middleware/identity-management/enterprise-sso/index.html
0
 
slightwv (䄆 Netminder) Commented:
>>can you login to oracle without a password,  well yes, single sign on

Semantics.  If you replace "password" with "authentication" then no, you still cannot connect without it.  Oracle needs some method to "authenticate" the connection.
0
 
Geert GOracle dbaCommented:
without providing it manually ...
better ?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.