Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 9.0.0 | 

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;