Security in Microsoft OLEDB for Oracle
This article deals with connection strings related to security and trusted connection in OLE DB Provider for Oracle.
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