HomeMogDBMogDB StackUqbar
v1.1

Documentation:v1.1

Supported Versions:

ALTER DIRECTORY

Function

ALTER DIRECTORY modifies a directory.

Precautions

  • Currently, only the directory owner can be changed.
  • The owner can only be a user with the sysadmin permission.

Syntax

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

-- Create a directory.
mogdb=# CREATE OR REPLACE DIRECTORY  dir  as '/tmp/';

-- Change the owner of the directory.
mogdb=# ALTER DIRECTORY dir OWNER TO system;

-- Delete the directory.
mogdb=# DROP DIRECTORY dir;
Copyright © 2011-2024 www.enmotech.com All rights reserved.