Controls whether a user is allowed to use the data extraction facility.
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.
'' (the empty string)
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 only the directories for which a user has write access.
See the section “Data extraction options” in Chapter 7, “Moving Data In and Out of Databases” of the Sybase IQ System Administration Guide for details on the data extraction facility and using the extraction options.
See also “TEMP_EXTRACT_NAMEn options.”
