GRANT OWNERSHIP

Syntax

GRANT OWNERSHIP ON 
      ( DATABASE database_name
      | SCHEMA [database_name.]schema_name
      | RELATION [[database_name.]schema_name.]relation_name
      | STORE store_name
      | SCHEMA_REGISTRY schema_registry_name
      | QUERY query_id
      | DESCRIPTOR_SOURCE descriptor_source_name
      | FUNCTION_SOURCE function_source_name
      | FUNCTION function_identifier
      | ROLE role_name
      )
TO roleName

Description

Transfer ownership or an object to a new Role.

Ownership can only be transferred if the current role is the owner or the object and has been granted the destination role.

Examples

demodb.public/<no-store># LIST DATABASES;
   Name  | Default |  Owner   |      Created at      |      Updated at       
---------+---------+----------+----------------------+-----------------------
  demodb | ✓       | sysadmin | 2023-09-10T20:59:20Z | 2023-09-10T20:59:20Z  
  
demodb.public/<no-store># GRANT OWNERSHIP ON DATABASE demodb TO rol1;

demodb.public/<no-store># LIST DATABASES;
   Name  | Default | Owner |      Created at      |      Updated at       
---------+---------+-------+----------------------+-----------------------
  demodb | ✓       | rol1  | 2023-09-10T20:59:20Z | 2023-09-10T20:59:20Z