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

Thread: Auto creating users in a second database

  1. #1
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    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
    Location
    Waterloo, On
    Posts
    547
    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 raminderahluwalia@rediffmail.com.

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