--===============================================
--== 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;
--===============================================
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/12476590/viewspace-628962/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/12476590/viewspace-628962/