<div>
The above comment is correct. &nbsp;I wish to throw in a professional observation that granting such system-level privileges is a security violation in many shops -- especially when you want to give someone other than the data (schema) owner permission to change DDL. &nbsp;Please, please reconsider your &quot;need&quot; to be so lax.<br />
Kind regards,<br />
dvz<br />
zone expert &nbsp;<br />

</div>


The above comment is correct.  I wish to throw in a professional observation that granting such system-level privileges is a security violation in many shops -- especially when you want to give someone other than the data (schema) owner permission to change DDL.  Please, please reconsider your "need" to be so lax.
Kind regards,
dvz
zone expert  


<div>
Hi,<br />
<br />
Agreed in a working (BUAT/live) environment you would not want to grant these privileges however I am setting up a development environment for a offshore resource who may need to alter, drop, and compile... <br />
<br />
Thanks Ian
</div>


Hi,

Agreed in a working (BUAT/live) environment you would not want to grant these privileges however I am setting up a development environment for a offshore resource who may need to alter, drop, and compile...

Thanks Ian

<div>
&quot;For droping the package of others schema &nbsp; the role &nbsp;should have a &nbsp;DROP ANY PROCEDURE system &nbsp;privilege.&quot; - Is it possible just to grant drop privileges on a single package..? 
</div>


"For droping the package of others schema   the role  should have a  DROP ANY PROCEDURE system  privilege." - Is it possible just to grant drop privileges on a single package..?

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
If I have created a package 'A' and I need to grant the following permissions on 'A' to a role 'R' how do I write this in SQL, the persmissions I need are..<br />
<br />
1) Drop both package body and header.<br />
2) Allow Compile.<br />
3) Execute permissions.<br />
4) Change the package code.<br />
<br />
Thanks Ian <br />
<br />
<br />

</div>
</div>


Hi,

If I have created a package 'A' and I need to grant the following permissions on 'A' to a role 'R' how do I write this in SQL, the persmissions I need are..

1) Drop both package body and header.
2) Allow Compile.
3) Execute permissions.
4) Change the package code.

Thanks Ian 




Oracle Grant Permissions on a Package

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.