ALTER SCHEMA OWNER

Forum|Forum|13 years ago
May 15, 2013
3 replies
9 views

+2

Pietro_La_Torre
Participating Frequently

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

A

+2

Anonymous
Participating Frequently
Forum|Forum|13 years ago
May 16, 2013

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.