1 Reply Latest reply: Oct 2, 2012 1:40 PM by 743274 RSS

    connecting to Oracle From SQL Server

    AG_DB
      I want know about, if I connecting to Oracle From SQL Server using ODAC is make any security issue ?

      I connected like below
      http://www.ideaexcursion.com/2009/01/05/connecting-to-oracle-from-sql-server/

      any other secure way for connecting SQL server? kindly help me.
        • 1. Re: connecting to Oracle From SQL Server
          743274
          Hi,
          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.