文章分类 -  oracle

oracle批量用户授权
摘要：(1)用游标实现 1 BEGIN 2 FOR lv_cur IN ( 3 select 'grant select on ' ||owner|| '.' ||table_name|| 'to user2' AS str from dba_tables where owner='USER1' 4 ) 阅读全文
posted @ 2020-04-06 19:44 5sdba 阅读(337) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示