Oracle Grant permission and Create SYNONYM

最新推荐文章于 2024-02-21 13:47:23 发布

congyaguan5319

最新推荐文章于 2024-02-21 13:47:23 发布

阅读量213

点赞数

文章标签：数据库

--===============================================
--== 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/