Usage Note 33150: The Oracle user ID and password are displayed in the SAS® log when you use the bulk-loading functionality in SAS/ACCESS® Interface to Oracle
When you run the bulk-loading functionality in SAS/ACCESS Interface to Oracle, you can see the Oracle user ID and password when you submit this command:
ps -ef | grep userid
To avoid displaying the password and to prevent a security violation, you need to embed the password in the SQL*Loader control file. To do this, use the bulk-loading option BL_PARFILE= to create a file that contains the SQL*Loader command-line options.
The following example demonstrates how SQL*Loader invocation is different when the BL_PARFILE= option is specified:
libname x oracle user=scott pw=tiger;
/* SQL*Loader is invoked, as follows, without the BL_PARFILE= option: */
/* unix_prompt> sqlldr userid=scott/tiger@oraclev9 control=bl_bltst_0.ctl */
/* log=bl_bltst_0.log bad=bl_bltst_0.bad discard=bl_bltst_0.dsc */
data x.bltst ( bulkload=yes);
c1=1;
run;
/* SQL*Loader is invoked, as follows, with the BL_PARFILE= option: */
/* unix_prompt> sqlldr parfile=test.par */
/* In this case, all of the options are written to the test.par file. */
/* Note that the following DATA step uses the BL_PARFILE= option. */
data x.bltst2 ( bulkload=yes bl_parfile='test.par');
c1=1;
run;
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to Oracle | z/OS | 9.1 TS1M3 | |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.1 TS1M3 | |
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.1 TS1M3 | |
| Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 | |
| Microsoft® Windows® for x64 | 9.1 TS1M3 | |
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 | |
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 | |
| Microsoft Windows 2000 Server | 9.1 TS1M3 | |
| Microsoft Windows 2000 Professional | 9.1 TS1M3 | |
| Microsoft Windows NT Workstation | 9.1 TS1M3 | |
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 | |
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 | |
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 | |
| Microsoft Windows XP Professional | 9.1 TS1M3 | |
| Windows Vista | 9.1 TS1M3 | |
| 64-bit Enabled AIX | 9.1 TS1M3 | |
| 64-bit Enabled HP-UX | 9.1 TS1M3 | |
| 64-bit Enabled Solaris | 9.1 TS1M3 | |
| HP-UX IPF | 9.1 TS1M3 | |
| Linux | 9.1 TS1M3 | |
| OpenVMS Alpha | 9.1 TS1M3 | |
| Tru64 UNIX | 9.1 TS1M3 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Date Modified: | 2008-09-12 15:14:42 |
| Date Created: | 2008-09-04 08:42:24 |