[b]从一个Schema复制到另一个Schema[/b]
/*check user privil*/
select * from user_tab_privs where TABLE_name = 'Source_Table'
/*in Source Schema*/
grant select on Source_Table to Destina_User;
/*in Destina Schma*/
insert into destina_schema.destina_table select column_value from souce_schema.source_table;
[b]拼凑批量语句[/b]
select 'grant select on '||table_name|| ' to UserName;' from user_tables;
/*check user privil*/
select * from user_tab_privs where TABLE_name = 'Source_Table'
/*in Source Schema*/
grant select on Source_Table to Destina_User;
/*in Destina Schma*/
insert into destina_schema.destina_table select column_value from souce_schema.source_table;
[b]拼凑批量语句[/b]
select 'grant select on '||table_name|| ' to UserName;' from user_tables;