Implement security in Oracle Provider for OLE DB

This article deals with connection strings related to security and trusted connection in Oracle Provider for OLE DB
  • 2017

Standard Security In OLEDB

OLEDB ia an application programming interface for accessing data from various heterogeneous languages. Thus the security of data and system is one of the major concerns to make sure that the is is secure and thus can be trusted. ORACLE implements the standard security in OLEDB. To implement the standard security use the following command.

Provider=OraOLEDB.Oracle;Data Source=yourOracleDB;User Id=Username;Password=user_Password;

Trusted Connection In OLEDB

The trusted connections is used in OLEDB to ensure that there proper authentication to the database and only the authorized people are accessing the system with their respective rights. this command requires the operating system authentication while connecting to the database.

Provider=OraOLEDB.Oracle;Data Source=yourOracleDB;OSAuthent=1;

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

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.