表授权给另一个用户

  select 'Grant all on '||table_name||' to dss ;' from all_tables
where owner = upper('gadata0008')

 

然后执行该语句的结果就可以了

grant all on user1.table1 to user2;

 

grant all on user1.* to user2

 

转载于:https://www.cnblogs.com/snake-hand/p/3163051.html