Genereator grant
Da wiki.gienne.cloud.
Versione del 18 set 2019 alle 10:40 di Admin (Discussione | contributi) (Creata pagina con " 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' a...")
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
