Help Center/ Data Warehouse Service / SQL Syntax Reference (8.1.3.x)/ DDL Syntax/ ALTER LARGE OBJECT
Updated on 2025-06-12 GMT+08:00
View PDF

ALTER LARGE OBJECT

Function

This syntax modifies the definition of a large object. The only function of ALTER LARGE OBJECT is to assign a new owner.

Precautions

Only the owner of a large object can run this command. System administrators have this permission by default.

Syntax

1
2
 
ALTER LARGE OBJECT large_object_oid 
    OWNER TO new_owner;

Parameter Description

Table 1 ALTER LARGE OBJECT parameters

Parameter

Description

Value Range

large_object_oid

OID of the large object to be modified

Name of an existing large object.

OWNER TO

Clause used to modify the owner of a large object

-

new_owner

Owner of a large object

Name of an existing user or role.

Examples

None.

Parent Topic: DDL Syntax