17,377
社区成员
发帖
与我相关
我的任务
分享
declare
v_objname varchar2(50);
v_str varchar2(100);
cursor v_cursor is
select object_name from user_objects where owner='USER1' and object_type='TABLE';
begin
open v_cursor;
loop
fetch v_cursor into v_objname;
exit when v_cursor%NOTFOUND;
v_str := 'grant all on '||v_objname||' to USER2';
execute immediate v_str;
end loop;
close v_cursor;
end;
/
declare
v_objname varchar2(50);
v_str varchar2(200);
cursor v_cursor is
select object_name from user_objects where owner='USER2' and object_type='TABLE';
begin
open v_cursor;
loop
fetch v_cursor into v_objname;
exit when v_cursor%NOTFOUND;
v_str := 'grant all on '||v_objname||' to USER1';
execute immediate v_str;
end loop;
close v_cursor;
end;
/
set serveroutput on
declare
v_objname varchar2(50);
cursor v_cursor is
select object_name from user_objects where owner='USER2' and object_type='TABLE';
begin
open v_cursor;
loop
fetch v_cursor into v_objname;
exit when v_cursor%NOTFOUND;
dbms_output.put_line('grant all on '||v_objname||' to USER2;');
end loop;
close v_cursor;
end;
/
grant select on 表名 to 用户;