oracle 利用字符拼接 开通只读账号

select 'grant select on ZD.'||Object_name||' to ZD;' from dba_objects where owner='OA';
create user ** identified by *;
GRANT connect to **;

 

转载于:https://blog.51cto.com/aixuexi/1053939