可以创建脚本来生成grant语句 再生成一个同义词的脚本,执行以下 具体如下: 在sqlplus下: set heading off set feedback off spool c:\aa.sql select 'grant all on '||object_name||' to aa;' from user_objects where object_type='TABLE'; select 'create public synonym for '||object_name||';' from user_objects where object_type='TABLE'; spool off @c:\aa.sql set heading on set feedback on
更正: select 'create public synonym '||object_name||' for '||object_name||';' from user_objects where object_type='TABLE';
再生成一个同义词的脚本,执行以下
具体如下:
在sqlplus下:
set heading off
set feedback off
spool c:\aa.sql
select 'grant all on '||object_name||' to aa;' from user_objects where object_type='TABLE';
select 'create public synonym for '||object_name||';' from user_objects where object_type='TABLE';
spool off
@c:\aa.sql
set heading on
set feedback on
select 'create public synonym '||object_name||' for '||object_name||';' from user_objects where object_type='TABLE';