将A用户所有表的权限赋予B用户
select 'grant select on '||owner||'.'||object_name|| ' to B;'
from dba_objects
where object_type='TABLE' and owner='A';
select 'grant select on '||owner||'.'||object_name|| ' to B;'
from dba_objects
where object_type='TABLE' and owner='A';