SQL> grant connect to user1 identified by user1;

Grant succeeded.

SQL> grant dba to data1 identified by data1;

Grant succeeded.

SQL> connect data1/data1
Connected.
SQL> create table a (a number);

Table created.

SQL> create role role_data1;

Role created.

SQL> grant select,insert,update,delete on a to role_data1;

Grant succeeded.

SQL> grant create procedure to role_data1;

Grant succeeded.

SQL> grant role_data1 to user1;

Grant succeeded.

SQL> connect user1/user1
Connected.
SQL> select * from data1.a;

no rows selected

SQL> create or replace procedure p1
  2  as
  3     cursor c1 is select * from data1.a;
  4  begin null;
  5  end;
  6  /

Warning: Procedure created with compilation errors.

SQL> show errors
Errors for PROCEDURE P1:

LINE/COL ERROR
-------- --------------------------------------------------------
3/17     PL/SQL: SQL Statement ignored
3/37     PL/SQL: ORA-00942: table or view does not exist

SQL> declare
  2     cursor c1 is select * from data1.a;
  3  begin null;
  4  end;
  5  /

PL/SQL procedure successfully completed.

SQL> connect data1/data1
Connected.
SQL> grant select,insert,update,delete on a to user1;

Grant succeeded.

SQL> connect user1/user1
Connected.
SQL> create or replace procedure p1
  2  as
  3     cursor c1 is select * from data1.a;
  4  begin null;
  5  end;
  6  /

Procedure created.

SQL> connect data1/data1
Connected.
SQL> revoke select,insert,update,delete on a from user1;

Revoke succeeded.

SQL> grant create any procedure to user1;

Grant succeeded.

SQL> connect user1/user1
Connected.
SQL> create or replace procedure data1.p1
  2  as
  3     cursor c1 is select * from data1.a;
  4  begin null;
  5  end;
  6  /

Procedure created.

1) ask your security team how they want you to handle multiple developers in the same database.

2) don't give system privileges out like candy.