Problem Note 8253: Export to database table fails when appending to an existing table
If a SAS Campaign Management user attempts to export to a database table
that already exists, and chooses to append to that table, the export may
fail due to insufficient database privileges. This problem occurs if
the table was created by another user, since the Campaign Management
application does not explicitly grant permissions to PUBLIC when it
creates an export table in the database.
To workaround the problem, the site DBA must manually grant permissions
for any export tables that will be accessed by multiple users.
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS Campaign Management | Microsoft Windows XP Professional | 7.2 | 7.5 |
| Microsoft Windows 2000 Professional | 7.2 | 7.5 |
| Microsoft Windows 2000 Server | 7.2 | 7.5 |
| Microsoft Windows 2000 Advanced Server | 7.2 | 7.5 |
| Microsoft Windows NT Workstation | 7.2 | 7.5 |
| Microsoft Windows 2000 Datacenter Server | 7.2 | 7.5 |
*
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.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2003-08-04 10:39:16 |
| Date Created: | 2002-08-14 10:41:37 |
