TNS and Security in Oracle
This article deals with TNS and integrated security in database as Oracle is one of th most powerful database and hence security one of the major parameters to be taken care of.
TNS In Oracle
Using TNS in orcale is very beneficial. TNS also known as The Connect Descriptor is used for connecting to the database service like protocol, port, host etc by defining the parameters needed by the Oracle. So in order to implement TNS use the following command.
|Data Source=TCP;User Id=Username;Password=User_Password;
NOTE: TNS coomand should be written using single quotes or in a single line.
Integrated Security In Oracle
Undoubtedly Oracle provides a sense of security by introducing the system of password and username. But still it does not not completely ensures 100% security of data. So in order to provide a better mechanism which could provide a better security is integrated security. It is basically another type of a database connection which ensures a trusted and efficient connection between the desktop and the server. So in order to implement integrated security in the oracle use the following command.
Data Source=TCP;Integrated Security=SSPI;
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