In Oracle, how can I give one user privileges to alter the schema of another user?
You can use CONNECT THROUGH to allow Dogbert to connect as Wally:

alter user wally grant connect through dogbert;
grant create session to dogbert;


To connect in sqlplus:

sqlplus dogbert[wally]/scottadams@DATABASE


Some tools may not support these proxy logins.