Problem Note 47797: When you use SAS/ACCESS® Interface to Oracle to create an Oracle table, the error "ORA-01031: insufficient privileges" occurs
 |  |  |  |  |
When you try to create an Oracle table using SAS/ACCESS® Interface to Oracle, you might receive the following error:
ERROR: Error attempting to CREATE a DBMS table.
ERROR: ORACLE execute error: ORA-01031: insufficient privileges.
This problem occurs when the USERID= option in the LIBNAME statement and the SCHEMA= data set or LIBNAME option have the same value. The SQL procedure's CREATE TABLE statement, which is passed to Oracle, does not contain the schema, only the table name. Oracle then tries to create the table using the user ID's schema, where the user does not have permission.
To work around the issue, create the Oracle table using the SQL pass-through facility.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Oracle | HP-UX IPF | 9.3 TS1M0 | 9.4 TS1M0 |
| 64-bit Enabled Solaris | 9.3 TS1M0 | 9.4 TS1M0 | ||
| 64-bit Enabled HP-UX | 9.3 TS1M0 | 9.4 TS1M0 | ||
| 64-bit Enabled AIX | 9.3 TS1M0 | 9.4 TS1M0 | ||
| Windows Vista for x64 | 9.3 TS1M0 | 9.4 TS1M0 | ||
| Windows Vista | 9.3 TS1M0 | 9.4 TS1M0 | ||
| Windows 7 Ultimate x64 | 9.3 TS1M0 | 9.4 TS1M0 | ||
| Windows 7 Ultimate 32 bit | 9.3 TS1M0 | 9.4 TS1M0 | ||
| Windows 7 Professional x64 | 9.3 TS1M0 | 9.4 TS1M0 | ||
| Windows 7 Professional 32 bit | 9.3 TS1M0 | 9.4 TS1M0 | ||
| Windows 7 Home Premium x64 | 9.3 TS1M0 | 9.4 TS1M0 | ||
| Windows 7 Home Premium 32 bit | 9.3 TS1M0 | 9.4 TS1M0 | ||
| Windows 7 Enterprise x64 | 9.3 TS1M0 | 9.4 TS1M0 | ||
| Windows 7 Enterprise 32 bit | 9.3 TS1M0 | 9.4 TS1M0 | ||
| Microsoft Windows XP Professional | 9.3 TS1M0 | 9.4 TS1M0 | ||
| Microsoft Windows Server 2008 for x64 | 9.3 TS1M0 | 9.4 TS1M0 | ||
| Microsoft Windows Server 2008 | 9.3 TS1M0 | 9.4 TS1M0 | ||
| Microsoft Windows Server 2003 for x64 | 9.3 TS1M0 | 9.4 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.3 TS1M0 | 9.4 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.3 TS1M0 | 9.4 TS1M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.3 TS1M0 | 9.4 TS1M0 | ||
| Microsoft® Windows® for x64 | 9.3 TS1M0 | 9.4 TS1M0 | ||
| z/OS | 9.3 TS1M0 | 9.4 TS1M0 | ||
| Linux | 9.3 TS1M0 | 9.4 TS1M0 | ||
| Linux for x64 | 9.3 TS1M0 | 9.4 TS1M0 | ||
| Solaris for x64 | 9.3 TS1M0 | 9.4 TS1M0 | ||
A fix for this issue for SAS/ACCESS Interface to Oracle 9.31_M1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/I33.html#47797| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2012-10-04 17:52:51 |
| Date Created: | 2012-09-05 09:49:55 |