--===============================================
--== Grant permission of sequences to RT_USER
--== select 'GRANT SELECT on RT_OWNER.'||sequence_name||' TO RT_USER;' FROM user_sequences order by sequence_name;
--===============================================

--===============================================
--== Grant permission of tables to RT_USER
--== Select 'GRANT SELECT,INSERT,UPDATE,DELETE on RT_OWNER.'||table_name||' TO RT_USER;' FROM user_tables order by table_name;
--===============================================

--===============================================
--== Create private SYNONYM for  sequneces in RT_OWNER
--== select 'CREATE OR REPLACE SYNONYM RT_USER.'||sequence_name||' FOR RT_OWNER.'||sequence_name||';' FROM user_sequences order by sequence_name;
--===============================================

--===============================================
--== Create private SYNONYM for  tables in RT_OWNER
--== select 'CREATE OR REPLACE SYNONYM RT_USER.'||table_name||' FOR RT_OWNER.'||table_name||';' FROM USER_TABLES order by table_name;
--===============================================