EG: jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=dbname;selectMethod=cursor
 Hi,

 I'm using JDBC to connect to MS SQL server. My Java code only need to link to the url (eg : ) to access the data. But some data are sensitive and I don't want any application and retrieve them. What can I do to restrict only some certain application can retrieve them ?

 Thanks

I dont fully  understand your problem.
You have database serwer and some database running on it. In that
database you have collection of information.
On which level want you to restrict conection?
Do you want to block connection to whole database serwer from specific
applications?
Or
do you want to restrict connections to database?
or maybe
you want to restric querys on specyfic tables in database (restric
retrieving information) from applications?

JS

Hi,

Isn't just enough to create a new user in your MS SQL with only the required
permissions, and then use that user in your Java application? That way, your
application will have only the permissions granted to that user.

For other applications, you can create another user with more privileges if
you want.

Erich

--
"xxxx" are to be removed from my email address