Oracle

从一个Schema复制到另一个Schema

/*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;


拼凑批量语句
select 'grant select on '||table_name|| ' to UserName;' from user_tables;