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