oracle-databaseprivileges

oracle privilege for Create or Replace only one package

Is there any way that we set edit (create or replace)privilege for only one package ? (suppose I have 10 package in my schema and need that other users could develop only one specific package in my schema )

Solution

  • we can add this oracle privileges to make this situation :

    grant execute any procedure to user;

grant debug any procedure to user;

grant debug connect session to user;