How to change owner of a Procedure in Redshift database

You have to be a super user to be able change the owner of a procedure. Below is the syntax where proc_name is the name of the procedure and datatype1, datatype2, datatype3 are the datatypes of arguments and new_owner is the name of the new owner.

ALTER PROCEDURE proc_name(datatype1, datatype2, datatype3,..) OWNER TO new_owner;

See also  How to drop a column from a table in Redshift database

Leave a Reply

Your email address will not be published. Required fields are marked *