79258305

Date: 2024-12-06 14:25:22
Score: 1
Natty:
Report link

You can create a ROLE for your developers and after they log in, they can alter session to this user who will be the owner of the development objects, for example:

1 - Your developers will log in to the DB.

2 - Run the command: alter session set current_schema=DEVELOPER_USER;

3 - From now on, every object created will be owned by DEVELOPER_USER.

4 - Regarding permissions, you can create a trigger or job that grants permissions when needed.

It is better to grant create any table, as this allows them to create tables for ANY user, which can be a big problem.

Reasons:
  • Long answer (-0.5):
  • No code block (0.5):
  • Low reputation (1):
Posted by: Eduardo Cunha