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

CREATE DIRECTORY and DROP DIRECTORY