How to create table on another schema ?
How to create table on another schema ? Question: we want to create table on anothere schema use different user; just like user a create table in user b. create user a identified by "pass" password expire account lock alter user a accountunlock; create user b identified by "pass" Solution: 1:for a simple solution, we can use 'grant create any table to a;' 2:anothere good one as follow: grant create session to a; grant create session to b; grant create table to a; create or replace procedure a.CreateTable(table_def varchar2) is BEGIN EXECUTE IMMEDIATE table_def ; END; create or replace synonym b.CreateTable for a.CreateTable; grant execute on a.CreateTable to b ; Test : begin CreateTable('create table t12345(name varchar(255))'); end;