Changes the definition of a protocol.
ALTER PROTOCOL <name> RENAME TO <newname>
ALTER PROTOCOL <name> OWNER TO <newowner>
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
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.
To rename the conversion
ALTER PROTOCOL GPDBauth RENAME TO GPDB_authentication;
To change the owner of the conversion
ALTER PROTOCOL GPDB_authentication OWNER TO joe;
There is no
ALTER PROTOCOL statement in the SQL standard.
Parent topic: SQL Commands