ALTER IMAGE REPOSITORY¶

Modifies the properties of an existing image repository.

See also:: CREATE IMAGE REPOSITORY , DROP IMAGE REPOSITORY , SHOW IMAGE REPOSITORIES

Syntax¶

ALTER IMAGE REPOSITORY [ IF EXISTS ] <name> SET
  [ COMMENT = '<string_literal>' ]

ALTER IMAGE REPOSITORY [ IF EXISTS ] <name> SET TAG <tag_name> = '<tag_value>' [ , <tag_name> = '<tag_value>' ... ]

ALTER IMAGE REPOSITORY [ IF EXISTS ] <name> UNSET TAG <tag_name> [ , <tag_name> ... ]

ALTER IMAGE REPOSITORY [ IF EXISTS ] <name> UNSET COMMENT

Parameters¶

name

Specifies the identifier for the image repository to alter.

If the identifier contains spaces or special characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive.

For more information, see Identifier requirements.

SET ...

Specifies the properties to set for the image repository:

TAG tag_name = 'tag_value' [ , tag_name = 'tag_value' , ... ]

Specifies the tag name and the tag string value.

The tag value is always a string, and the maximum number of characters for the tag value is 256.

For information about specifying tags in a statement, see Tag quotas.

COMMENT = 'string_literal'

Specifies a comment for the image repository.

Default: No value

UNSET ...

Specifies the property to unset for the image repository, which resets it to the default value:

TAG tag_name [ , tag_name ... ]
COMMENT

To unset multiple properties or parameters with a single ALTER statement, separate each property or parameter with a comma.

When unsetting a property or parameter, specify only the property or parameter name (unless the syntax above indicates that you should specify the value). Specifying the value returns an error.

Access control requirements¶

A role used to execute this operation must have the following privileges at a minimum:

Privilege	Object	Notes
OWNERSHIP	Image repository

Operating on an object in a schema requires at least one privilege on the parent database and at least one privilege on the parent schema.

For instructions on creating a custom role with a specified set of privileges, see Creating custom roles.

For general information about roles and privilege grants for performing SQL actions on securable objects, see Overview of Access Control.

Examples¶

The following example sets a comment on the repository named tutorial_repository:

ALTER IMAGE REPOSITORY tutorial_repository SET COMMENT = 'Images for the tutorial services';

The following example removes the comment:

ALTER IMAGE REPOSITORY tutorial_repository UNSET COMMENT;