Home » SQL & PL/SQL » SQL & PL/SQL » Retrieving java permissions
Retrieving java permissions [message #201340] Fri, 03 November 2006 10:37 Go to next message
yonieilon
Messages: 13
Registered: October 2006
Junior Member
I would like to know if there is a way to retrieve Java permissions granted to a certain user using DBMS_JAVA.GRANT_PERMISSION.

For example, if someone executed the command:
EXEC dbms_java.grant_permission('PUBLIC', 'java.io.FilePermission','*','*');


How can I later know what permission was granted to PUBLIC?

Thanks,
Yoni.
Re: Retrieving java permissions [message #201349 is a reply to message #201340] Fri, 03 November 2006 11:20 Go to previous messageGo to next message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
select *
  from dba_java_policy
 where grantee = 'PUBLIC';
Re: Retrieving java permissions [message #201352 is a reply to message #201340] Fri, 03 November 2006 11:24 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Select * from DBA_JAVA_POLICY where type_name like 'java.io.%'
-- and grantee in ( 'SCOTT', 'PUBLIC');
Re: Retrieving Java permissions [message #201353 is a reply to message #201340] Fri, 03 November 2006 11:32 Go to previous message
yonieilon
Messages: 13
Registered: October 2006
Junior Member
Just what I needed, thanks very much!
Previous Topic: Insert into a table
Next Topic: Problem with Sequence Value after Export
Goto Forum:
  


Current Time: Tue Dec 06 08:29:40 CST 2016

Total time taken to generate the page: 0.14107 seconds