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
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.
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