should i grant permision using dbms_java package with sys user

Posted on 2008-11-04
Last Modified: 2013-12-19
i am using dbms_javapackage to grant file permission to user but it is giving an  ora-29532 java.lang securityException: policy update permission. i can compile without errors but then it crops the runtime error.

should i use sys user to grant permission or i can use normal user


-- grant permission to frost_addons


-- get file quantity

select recon_GetFileqty('/Jan08/') into v_file_qty from dual;



Open in new window

Question by:marcia1
    1 Comment
    LVL 34

    Accepted Solution

    I think you have to use the SYS account to do this grant, but grants (and other DDL commands) are usually done with *.SQL scripts or interactively in SQL*Plus or another tool, not usually in a PL\SQL procedure like this.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    This post first appeared at Oracleinaction  ( Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
    From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
    This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
    This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now