Actually, new permissions are not visible to sessions that were connected when
grants took place. It seems that once the session is established and classes are
instantiated, the security manager does not re-read permissions table (which is
a good thing because otherwise the performance would be severely affected).
I don't think that bouncing the db is necessary step - new connections will read
modified permissions table and will see the changes.
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"Yann CAUCHARD" <yann.cauchard_at_spcconsultants.com> wrote in message
news:a90sn0$1b72$1_at_news5.isdnet.net...
> Hi,
>
> 8.1.6 on NT.
>
> I created a java procedure to rename a file.
> I tried to execute it and get an error about "java.io.FilePermission read"
> not granted and so on.
> I granted all permission on all files to the right user.
>
> It worked, BUT only after the database stopped and restarted.
>
> Is stopping and restarting the DB the only solution to achieve JAVA granting
> ?
> Or is there something I forgot or made wrong ?
>
> Thanks.
>
> yann
>
>
Received on Thu Apr 11 2002 - 08:47:38 CDT
