Controls whether a user is allowed to use the data extraction facility.
string
'' (the empty string)
Can be set temporary, per user, or for the PUBLIC group. DBA authority is required to set the option. This option takes effect immediately.
If the TEMP_EXTRACT_DIRECTORY option is set to the string FORBIDDEN (case insensitive) for a user, then that user is not allowed to perform data extracts. An attempt by this user to use the data extraction facility results in an error.
If TEMP_EXTRACT_DIRECTORY is set to FORBIDDEN for the PUBLIC group, then no one can run data extraction.
This option provides increased security and helps control disk management by restricting the creation of large data extraction files to the directories for which a user has write access.
For details on the data extraction facility and using the extraction options, see “Data extraction options” in Chapter 7, “Moving Data In and Out of Databases” in the Sybase IQ System Administration Guide.
