I want know about, if I connecting to Oracle From SQL Server using ODAC is make any security issue ?
I connected like below
any other secure way for connecting SQL server? kindly help me.
if you want grant access from computer A and restrict access from computer B to schema under the same database user you shoild consider [Oracle Database Vault|http://docs.oracle.com/cd/B28359_01/server.111/b31222/dvintro.htm]
For example, you can restrict access to schema from ranged ip, grant access to specific user and even hide data from sys user.