The Vertica Forum is getting a makeover! The site will be undergoing maintenance from Tuesday 8/13 to Friday 8/16. We appreciate your patience and cooperation during this time.
ALTER SCHEMA OWNER
Hi everyone! I have a user talend_dwh which is owner of schema replica. I want to drop this user and let the user dbadmin be its new owner, without losing the schema and its content. The problem is: I cannot drop the user without dropping also the schema and the istruction: ALTER SCHEMA replica OWNER TO dbadmin; is not supported. Could anyone tell me how to solve this problem? thanks