Security in Microsoft OLEDB for Oracle

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

Standard security

The connection string given below is used for implementing standard security in the database so that data which is present will remain safe and intact without any interference from any unauthorized user. The requires the attributes- username and password which implements the security. To implement the security use the following command.

Provider=msdaora;Data Source=userOracleDB;User Id=Username;Password=user_Password;

Trusted connection

The command given below is used for used for making trusted connections between oracle and  OLE DB Provider to ensure that the data is safe and thus can be used without any problem.

Provider=msdaora;Data Source=UserOracleDB;Persist Security Info=False;Integrated Security=Yes;

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

© 2019 DotNetHeaven. All rights reserved.