ALTER SCHEMA OWNER

Pietro_La_Torre

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

[Deleted User]

You could do: alter table t1 set schema new_replica; for each table tn in the replica schema, and then drop schema replica. It's a bit cumbersome, but this sounds like a one-time operation, so maybe that's OK.

Pietro_La_Torre

that worked! thanks!

Jim_Knicely

Fyi...

Vertica 9.1.1 now supports transferring schema ownership!

See:
https://my.vertica.com/docs/9.1.x/HTML/index.htm#Authoring/SQLReferenceManual/Statements/ALTERSCHEMA.htm