Auto creating users in a second database Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Auto creating users in a second database

  1. #1
    Join Date
    Jan 2000
    Chester, England.
    I'd like to be able to have any Oracle users created in one database, to be created automatically in a second database.

    Anyone suggest anything?

    Basically I want same username/passwords in both databases so that the 'joining' of app A and app B is seamless to the user. So when App A creates an Application user as well as the Oracle user I'd like - somehow - for an identical user to be created in the database that App B uses.

    Anyone ever done anything like this? I'm using 8.1.5 on NT4

  2. #2
    Join Date
    Aug 2001
    Waterloo, On
    I think you can create a db link and then modify your user creation scripts to create user in both the databases.

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i

    Mail me at

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width