Enable Security in .NET Framework for Oracle

This article gives information about standard string and the implementation of username and password in .NET Framework Data Provider for Oracle.
  • 2236

Standard for Oracle in .NET Framework Data Provider

The NET Framework Data Provider for oracle is a very impressive tool as it has features such as OS authentication DBA privileges to open a session with and Proxy Authentication which are highly beneficial to be used..The connection string given below is as standard string which is being used for .NET Framework Data Provider for oracle. Integrated security attribute signifies that there will be a higher level of security than which could be provided by password attribute.

Data Source=yourOracleDB;Integrated Security=yes;
NOTE: The string given above is valid for Oracle 8i release 3 or higher versions.

Specifying username and password

Username and password is used to establish security in a database to ensure that only authorized user can access the system and the data which is there is valid and can be trusted. To implement username and password use the following connection string. Here integrated security attribute is usually set to NO.

Data Source=yourOracleDB;User Id=Username;Password=user_Password;Integrated Security=no;
NOTE: The string given above is valid for Oracle 8i release 3 or higher versions.

Further Readings

You may also want to read these related articles.

Ask Your Question

Got a programming related question? You may want to post your question here

Programming Answers here


More Articles

© 2020 DotNetHeaven. All rights reserved.