02 2020 档案

ORACLE 下查看用户session 及 kill 用户session

摘要：SQL> drop user test cascade;drop user test cascade*ERROR at line 1:ORA-01940: cannot drop a user that is currently connected SQL> select sid,serial# f 阅读全文

posted @ 2020-02-21 19:02 菜鸟大明儿哥阅读(1350) 评论(0) 推荐(0) 编辑

oracle 存储过程、函数和包的权限

摘要：GRANT CREATE ANY PROCEDURE TO MONKEY --创建、查看、替换权限 GRANT EXECUTE ANY PROCEDURE TO MONKEY --执行和查看的权限 GRANT ALTER ANY PROCEDURE TO MONKEY --编译的权限 GRANT D 阅读全文

posted @ 2020-02-14 12:26 菜鸟大明儿哥阅读(1372) 评论(0) 推荐(0) 编辑