set pages 999;
set heading off;
spool d:\run_grant.sql
select 'grant select on '||owner||'.'||object_name|| ' to user1;'
from dba_objects
 where object_type='TABLE'  and owner='SCOTT';
spool off;

原创文章，转载请注明： 转载自TQ 试用 WP

本文链接地址: Oracle 创建只读用户

Post Footer automatically generated by wp-posturl plugin for wordpress.

Most Commented Posts