OraFAQ Forum: SQL & PL/SQL » Retrieving java permissions

Home » SQL & PL/SQL » SQL & PL/SQL » Retrieving java permissions

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Retrieving java permissions [message #201340]

Fri, 03 November 2006 10:37

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.

Report message to a moderator

Re: Retrieving java permissions [message #201349 is a reply to message #201340]

Fri, 03 November 2006 11:20

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

select *
  from dba_java_policy
 where grantee = 'PUBLIC';

Report message to a moderator

Re: Retrieving java permissions [message #201352 is a reply to message #201340]

Fri, 03 November 2006 11:24

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');

Report message to a moderator

Re: Retrieving Java permissions [message #201353 is a reply to message #201340]

Fri, 03 November 2006 11:32

yonieilon
Messages: 13
Registered: October 2006

Junior Member

Just what I needed, thanks very much!

Report message to a moderator

Previous Topic:	Insert into a table
Next Topic:	Problem with Sequence Value after Export

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 14 14:10:51 CST 2024