build sql with sql

[Sweetie]

hi

i need to create a role with dml privilege on a user´s tables

i used this


select 'grant select, insert, delete, update on ' privilege, owner,'.', table_name
from dba_tables where owner='ICDBA'
order by 3;

and I get


PRIVILEGE OWNER ' TABLE_NAME
---------------------------------------- ----- - ------------------------------

grant select, insert, delete, update on IC . EVT_CARRIER_CONFIGURATION
grant select, insert, delete, update on IC . EVT_DEST_PROFILE
grant select, insert, delete, update on IC . EVT_HISTORY



is there anyway to achieve

grant select, insert, delete, update on IC.EVT_HISTORY

getting rid of spaces between lines?

[m1l]

Try

select 'grant select, insert, delete, update on ' || owner || '.' || table_name
from dba_tables