create user ro_datagrp identified by "DDr8jCGOmT677Wbx";
grant connect to ro_datagrp;
declare
v_sql varchar2(2000);
CURSOR cur_grant IS select 'grant select,update,delete,insert on '||owner||'.'||table_name||' to ro_datagrp' from dba_tables where owner='PROD_GG';
begin
open cur_grant;
loop
fetch cur_grant into v_sql;
exit when cur_grant%notfound;
dbms_output.put_line(v_sql);
execute immediate v_sql;
end loop;
close cur_grant;
end;
/
grant connect to ro_datagrp;
declare
v_sql varchar2(2000);
CURSOR cur_grant IS select 'grant select,update,delete,insert on '||owner||'.'||table_name||' to ro_datagrp' from dba_tables where owner='PROD_GG';
begin
open cur_grant;
loop
fetch cur_grant into v_sql;
exit when cur_grant%notfound;
dbms_output.put_line(v_sql);
execute immediate v_sql;
end loop;
close cur_grant;
end;
/