环境:oracle
- 给用户多表只读权限
select 'grant select on '||owner||'.'||object_name||'' to 用户名;' from dba_objects where owner in (‘owner’) and object_type='TABLE';
- 批量创建多个同义词
SELECT 'create or replace SYNONYM 用户名.'||object_name||' FOR '||owner||'.'||object_name||';' from dba_objects where owner in (‘owner’) and object_type=’TABLE’;
标签:name,批量,dba,object,owner,Oracle,授权,select From: https://www.cnblogs.com/wa-zz/p/17391294.html