“访问被拒绝";在设置DBMS_XDB.SETHTTPORT时 [英] "Access denied" while setting DBMS_XDB.SETHTTPORT
本文介绍了“访问被拒绝";在设置DBMS_XDB.SETHTTPORT时的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我以普通用户身份登录数据库:
I was logged in as a normal user into the database:
SQL> connect
Enter user-name: myusername
Enter passwort:
Connected.
然后我尝试设置默认的http端口,如下所示:
And then I tried to set the default http port like this:
SQL> Exec DBMS_XDB.SETHTTPPORT(3000);
但是我收到以下错误消息:
But I got the following error message:
ERROR at line 1:
ORA-31050: Access denied
ORA-06512: at "XDB.DBMS_XDB", line 528
ORA-06512: at "XDB.DBMS_XDB", line 667
ORA-06512: at line 1
出了什么问题?也许因为我不是管理员用户?但是如何添加管理员用户?
What was going wrong? Perhaps because i am not an admin user? But how to add an admin user?
推荐答案
看看这个:
SQL> conn hr/hr
Connected.
SQL> exec dbms_xdb.sethttpport(3000);
BEGIN dbms_xdb.sethttpport(3000); END;
*
ERROR at line 1:
ORA-31050: Access denied
ORA-06512: at "XDB.DBMS_XDB", line 528
ORA-06512: at "XDB.DBMS_XDB", line 667
ORA-06512: at line 1
SQL> conn / as sysdba
Connected.
SQL> exec dbms_xdb.sethttpport(3000);
PL/SQL procedure successfully completed.
SQL> grant execute on dbms_xdb to hr
2 /
Grant succeeded.
SQL> conn hr/hr
Connected.
SQL> exec dbms_xdb.sethttpport(3002);
BEGIN dbms_xdb.sethttpport(3002); END;
*
ERROR at line 1:
ORA-31050: Access denied
ORA-06512: at "XDB.DBMS_XDB", line 528
ORA-06512: at "XDB.DBMS_XDB", line 667
ORA-06512: at line 1
SQL> conn / as sysdba
Connected.
SQL> grant sysdba to hr
2 /
Grant succeeded.
SQL> conn hr/hr as sysdba
Connected.
SQL> exec dbms_xdb.sethttpport(3003);
PL/SQL procedure successfully completed.
因此,您必须具有SYSDBA特权才能执行此程序包.
So you must have the SYSDBA privilege to execute this package.
这篇关于“访问被拒绝";在设置DBMS_XDB.SETHTTPORT时的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文