Genereator grant
Da wiki.gienne.cloud.
SET HEAD OFF SPOOL QUERY.SQL select 'grant select on USER_PROPRIETARIO.' || object_name || ' to USER_DESTINATA;' from all_objects where owner like 'USER_PROPRIETARIO' and object_type='TABLE'; SPOOL OFF START QUERY.SQL
