oracle - As a non-DBA user, how can I pass on scripts to other users that work in their own Schema? -

here's situation. i'm non-dba user in oracle database. such, have ddl , dml privileges own schema, can create, drop, update, etc tables in own schema.

so let's write script creates , updates tables in own schema (let's call schema user1). when day comes leave company , need pass script on replacement (let's user2), how do if script works user1? user2 have go through script , replace references of user1 user2?

point being i'd script work regardless user runs without having tinker it.

first, if it's production script creates tables application , manipulates it's data, shouldn't run own user, dedicated production user.

regardless, if you're running script in own schema, doesn't need explicitly reference it. remove references schema, , objects created under user running it, meaning user can run own account (assuming has basic dml/ddl permissions script requires).