SQL> create or replace
  2    package pkg1
  3      is
  4        procedure p1;
  5  end;
  6  /

Package created.

SQL> create or replace
  2    package body pkg1
  3      is
  4        procedure p1
  5          is
  6          begin
  7              null;
  8        end;
  9  end;
 10  /

Package body created.

SQL> create user u1 identified by u1 default tablespace users quota unlimited on users;

User created.

SQL> grant create session to u1;

Grant succeeded.

SQL> grant debug,execute on pkg1 to u1;

Grant succeeded.

SQL> connect u1@pdb1sol122
Enter password:
Connected.
SQL> exec scott.pkg1.p1

PL/SQL procedure successfully completed.

SQL> alter package scott.pkg1 compile;
alter package scott.pkg1 compile
*
ERROR at line 1:
ORA-01031: insufficient privileges


SQL> create or replace
  2    package scott.pkg1
  3      is
  4        procedure p1;
  5        procedure p2;
  6  end;
  7  /
create or replace
*
ERROR at line 1:
ORA-01031: insufficient privileges


SQL> select  text
  2    from  all_source
  3    where owner = 'SCOTT'
  4      and name = 'PKG1'
  5    order by type,
  6             line
  7  /

TEXT
--------------------------------------------------------------------------------
package pkg1
    is
      procedure p1;
end;
package body pkg1
    is
      procedure p1
        is
        begin
            null;
      end;
end;

12 rows selected.

SQL>