Usage Note 19072: Accessing an Oracle Virtual Private Database
 |  |  |  |
Some sites are using the Oracle Virtual Private Database (VPD) as a way to provide Row Security.
The VPD will automatically alter a query, based on the user ID and password specified at connection, and return results that are only applicable to that specific user.
Since the actual query altering happens on the Oracle side, there is nothing that needs to change in the SAS/ACCESS® code.
Using SAS/ACCESS software, make sure that the desired Oracle user ID and Oracle password are specified so that the appropriate results are returned to the SAS® System.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Oracle | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | |
| Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 | |||
| Microsoft Windows NT Workstation | 9.1 TS1M3 | |||
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 | |||
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 | |||
| Microsoft Windows 2000 Server | 9.1 TS1M3 | |||
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 | |||
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 | |||
| Microsoft Windows XP Professional | 9.1 TS1M3 | |||
| Microsoft Windows 2000 Professional | 9.1 TS1M3 | |||
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 | |||
| Type: | Usage Note |
| Priority: | low |
| Topic: | SAS Reference ==> Procedures ==> ACCESS |
| Date Modified: | 2008-05-05 09:27:03 |
| Date Created: | 2006-11-28 15:43:38 |