ALTER PROTOCOL
Changes the definition of a protocol.
Synopsis
ALTER PROTOCOL <name> RENAME TO <newname>
ALTER PROTOCOL <name> OWNER TO <newowner>Description
ALTER PROTOCOL changes the definition of a protocol.
Only the protocol name or owner can be altered.
You must own the protocol to use ALTER PROTOCOL.
To alter the owner, you must also be a direct or indirect member of the new owning role, and that role must have the CREATE privilege on schema of the conversion.
These restrictions are in place to ensure that altering the owner only makes changes that could by made by dropping and recreating the protocol. Note that a superuser can alter ownership of any protocol.
Parameters
| Parameter | Description |
|---|---|
name |
The name of an existing protocol |
newname |
The new name of the protocol |
newowner |
The new owner of the protocol |
Examples
Rename a protocol:
ALTER PROTOCOL oldname RENAME TO newname;Change the owner of a protocol:
ALTER PROTOCOL myprot OWNER TO newowner;Compatibility
There is no ALTER PROTOCOL statement in the SQL standard.
ALTER PROTOCOL is a Greenage DB extension.