How can I replicate a schema in Oracle with the same permissions as an existing account?We frequently receive requests to replicate user accounts with the same rights as other users in Oracle for IT clients' ticketing operations/requests.
We can use Oracle SQL Developer,
Navigate to VIEW menu and select DBA.
Connect to the database in DBA by selecting the database.
Navigate to Security and then to Users.
select the user you want to replicate like.
Right-click.
Choose, Create Like.
Toggle on 'Copy object privs'
Click on SQL for the DDL.