Oracle中给用户授予debug权限

来源:互联网 发布:工信部大数据基准测试 编辑:程序博客网 时间:2024/05/17 03:22
错误报告 -
SQL 错误: ORA-01031: 权限不足
ORA-06512: 在 "SYS.DBMS_DEBUG_JDWP", line 68
ORA-06512: 在 line 1
01031. 00000 -  "insufficient privileges"
*Cause:    An attempt was made to perform a database operation without
           the necessary privileges.
*Action:   Ask your database administrator or designated security

           administrator to grant you the necessary privileges


步骤:

1. 使用管理员用户登录: SQL> conn sys/sys as sysdba

2. 给需要授权的用户授权:SQL> GRANT debug any procedure, debug connect session TO 用户;

0 0