SQL ORA-01031: 创建包时权限不足
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/144113/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
ORA-01031: insufficient privileges when creating package
提问by Igor Zelaya
I'm getting ORA-01031: insufficient privileges when creating a package my own schema. Shouldn't I have complete control over my schema. If this is not the case, what privileges does my schema need?
我收到 ORA-01031: 创建包我自己的架构时权限不足。我不应该完全控制我的架构。如果不是这种情况，我的架构需要什么权限？
回答by user7116
You may need to have GRANT CREATE PROCEDURE TO USERNAME.
您可能需要GRANT CREATE PROCEDURE TO USERNAME。
回答by Igor Zelaya
If you are referencing tables that are not in your schema you may get this error even if you can select data from the tables. The problem is that permissions granted by roles work for sql but do not work for PL/SQL. PL/SQL requires the rights be granted to the user.
如果您引用的表不在您的架构中，即使您可以从表中选择数据，您也可能会收到此错误。问题是角色授予的权限适用于 sql，但不适用于 PL/SQL。PL/SQL 需要授予用户权限。
Another possible issue is that you do not have the create procedure system priviledge which is need to create procs.
另一个可能的问题是您没有创建过程所需的创建过程系统特权。
