DBA GENESIS

  • Courses

  • Certification

  • Contact

  • Members

  • More

    Use tab to navigate through the menu items.

    Book a mock interview and get instant feedback - Learn More

    To see this working, head to your live site.
    • Categories
    • All Posts
    • My Posts
    Piyush Ranjan
    Jul 05

    Oracle Database Create user same as existing user

    in Oracle Database Administration

    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.

    1 answer0 replies
    0
    1 Comment

    Share Your ThoughtsSign up to leave a comment.

    Piyush Ranjan
    Jul 05
    •

    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.




    1
    1 comments
    Similar Posts
    • Oracle Database Auditing
    • Create New Password_Verify Function in Oracle database 19c
    • Oracle Database Create Trigger

    support@dbagenesis.com

    • Facebook
    • Instagram
    • Twitter
    • YouTube

    © 2023 Biggest Database Forum by DBA Genesis