Grant to create or edit PKG

you can allow a user A to assume B's identity who has already privileges for a specific package :

create user a identified by a;
grant create session, create procedure to a;
create user b identified by b default tablespace users quota unlimited on users; grant create session, create table, create procedure to b;
alter user b grant connect through a;

so user A uses their own password to "become" B.

but that would give them the ability to do more than just edit B's packages - it would allow them to do anything B can do (as shown by creating a table).

you can restrict that somewhat by using roles - but not entirely (since some things will be granted directly to B).

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Amira Bedhiafi5y ago
you can allow a user A to assume B's identity who has already privileges for a specific package :
create user a identified by a;
grant create session, create procedure to a;
create user b identified by b default tablespace users quota unlimited on users; grant create session, create table, create procedure to b;
alter user b grant connect through a;
so user A uses their own password to "become" B.
but that would give them the ability to do more than just edit B's packages - it would allow them to do anything B can do (as shown by creating a table).
you can restrict that somewhat by using roles - but not entirely (since some things will be granted directly to B).
0