Re: DBMS_JAVA.GRANT

From: Jeremy Ovenden <newsposter_at_hazelweb.co.uk>
Date: Mon, 10 Jun 2002 11:28:58 +0100
Message-ID: <ae1uv7$37kbb$1@ID-140241.news.dfncis.de>

"Thomas Kyte" <tkyte_at_oracle.com> wrote in message news:adttug02g21_at_drn.newsguy.com...
> In article <adqe05$1g3fa$1_at_ID-140241.news.dfncis.de>, "Jeremy
says...
> >
> >Is there an opposite to this e.g.

DBMS_JAVA.REVOKE_PERMISSION?
> >
> >How does one remove privileges given via
> >DBMS_JAVA.GRANT_PERMISSION ?
> >
> >This is on Oracle 8i 8.1.6 .....
> >
> >--
> >Jeremy Ovenden
> >
> >
> >
>
> simple describe of dbms_java shows....
> ops$tkyte_at_ORA817DEV.US.ORACLE.COM> desc dbms_java
> PROCEDURE AURORA_SHUTDOWN
> PROCEDURE DELETE_EP
> ....
> PROCEDURE REVOKE_PERMISSION
> Argument Name Type In/Out
Default?
> ------------------------------ ----------------------- ------

> GRANTEE VARCHAR2 IN
> PERMISSION_TYPE VARCHAR2 IN
> PERMISSION_NAME VARCHAR2 IN
> PERMISSION_ACTION VARCHAR2 IN
> PROCEDURE SERVER_SHUTDOWN
> PROCEDURE SERVER_STARTUP
> .....
>
> that yes, there is.
>
> --
> Thomas Kyte (tkyte_at_oracle.com)

http://asktom.oracle.com/
> Expert one on one Oracle, programming techniques and solutions
for Oracle.
> http://www.amazon.com/exec/obidos/ASIN/1861004826/
> Opinions are mine and do not necessarily reflect those of
Oracle Corp
>

Hi Tom - that's what I tried first and the output I got is:

desc dbms_java
...
...
FUNCTION RESOLVER RETURNS VARCHAR2

 Argument Name                  Type                    In/Out

Default?

----------------------- ------ -
NAME VARCHAR2 IN OWNER VARCHAR2 IN TYPE VARCHAR2 IN PROCEDURE RESTART_DEBUGGING Argument Name Type In/Out Default?
----------------------- ------ -
TIMEOUT NUMBER IN PROCEDURE SERVER_SHUTDOWN PROCEDURE SERVER_STARTUP PROCEDURE SET_COMPILER_OPTION Argument Name Type In/Out Default?
----------------------- ------ -
WHAT VARCHAR2 IN OPTIONNAME VARCHAR2 IN VALUE VARCHAR2 IN ... ...

Is this a difference then between 8.1.6 & 8.1.7 ?

cheers

--
jeremy

Received on Mon Jun 10 2002 - 05:28:58 CDT

Re: DBMS_JAVA.GRANT_PERMISSION