Changing Owner

Description

Database Administrator (DBA) or a member of the DBA group can change the owner of table, view, trigger, and Java stored functions/procedures by using the following query.

Syntax

ALTER [TABLE | CLASS | VIEW | VCLASS | TRIGGER | PROCEDURE | FUNCTION] name OWNER TO user_id;

• name: The name of schema object of which ower is to be changed
• user_id: User ID

Example

ALTER TABLE test_tbl OWNER TO public;

ALTER VIEW test_view OWNER TO public;

ALTER TRIGGER test_trigger OWNER TO public;

ALTER FUNCTION test_function OWNER TO public;

ALTER PROCEDURE test_procedure OWNER TO public;