changeCompositeTypeOwner
The changeCompositeTypeOwner
Change Type allows you to change the user who owns the composite type. The new owner can alter, drop, grant, revoke, or transfer ownership to another user.
Run changeCompositeTypeOwner
To run this Change Type, follow these steps:
Add the Change Type to your changeset, as shown in the examples on this page.
Specify any required attributes. Use the table on this page to see which ones your database requires.
Deploy your changeset by running the
update
command:liquibase update
Available attributes
Name | Type | Description | Requirement |
| String | Name of the catalog. | Optional |
| String | Name of the schema that contains the composite type. | Optional |
| String | Name of the type you want to change the owner of. | Required |
| String | Name of the new user who is designated as the owner of the composite type. Accepted values are: | Required |
changeCompositeTypeOwner examples
databaseChangeLog:
- changeSet:
id: 1
author: itTest
changes:
- createCompositeType:
typeName: "myType"
typeAttributes:
- typeAttribute:
name: "attr1"
type: "int"
- typeAttribute:
name: "attr2"
type: "text"
collation: "en_US"
- changeCompositeTypeOwner:
typeName: "myType"
newOwner: "SESSION_USER"
rollback:
- dropCompositeType:
typeName: "myType"
ifExists: true
onDelete: "CASCADE"