Updated on 2024-10-14 GMT+08:00
ALTER DIRECTORY
Function
ALTER DIRECTORY modifies a directory.
Precautions
- Currently, only the directory owner can be changed.
- When enable_access_server_directory is set to off, only the initial user is allowed to change the directory owner. When enable_access_server_directory is set to on, users with the SYSADMIN permission and the directory object owner can change the directory object owner, and the user who changes the owner is required to be a member of the new owner.
Syntax
1 2 |
ALTER DIRECTORY directory_name OWNER TO new_owner; |
Parameter Description
directory_name
Specifies the name of a directory to be modified. The value must be an existing directory name.
Examples
1 2 3 4 5 6 7 8 |
-- Create a directory. openGauss=# CREATE OR REPLACE DIRECTORY dir as '/tmp/'; -- Change the owner of the directory. openGauss=# ALTER DIRECTORY dir OWNER TO system; -- Delete the foreign table. openGauss=# DROP DIRECTORY dir; |
Helpful Links
Parent topic: SQL Syntax
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbot