secure_file_priv specifies the path in which file import and export can be performed. This variable can be specified only by the database administrator (DBA).
| Attribute | Description |
|---|---|
| Type | Varchar |
| Default value | NULL |
| Value range | NULL: File import and export are disabled. |
| Applicable scope | Global |
| Plan generation affected | Yes |
| Nullable | Yes |
You can use this variable to modify the directory where the secure file resides and set the directory to an empty string. Example:
obclient> SET GLOBAL secure_file_priv = "";
Notice
For security reasons, you can execute the SQL statement that modifies the global variable only by using an OBClient whose server has the same IP address as that of the server where the connected OBServer node is located.