Oracle:在哪里可以查询 Java 授权?
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/3191180/
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
Oracle: where can I query java grants?
提问by Mark Harrison
I need to check the current user's java grants, something similar to what has been set by:
我需要检查当前用户的 java 授权,类似于以下设置的内容:
dbms_java.grant_permission('SCOTT','java.net.SocketPermission','*','connect');
dbms_java.grant_permission('SCOTT','java.net.SocketPermission','*','connect');
Can this be done without system privs from the current account? If I need to do it with system privs, where should I look?
这可以在没有当前帐户的系统权限的情况下完成吗?如果我需要使用系统权限来做,我应该在哪里看?
10gR2, if that makes a difference.
10gR2,如果这有区别的话。
采纳答案by dpbradley
This should show up in the DBA_JAVA_POLICY and USER_JAVA_POLICY views.
这应该显示在 DBA_JAVA_POLICY 和 USER_JAVA_POLICY 视图中。
回答by wahid
begin
dbms_java.grant_permission(grantee => 'CALL_RECORDING',
permission_type => 'java.io.FilePermission',
permission_name => 'D:/AES/-',
permission_action => 'execute,read,write,delete');
commit;
end;