Home : Products : OPS SQL : Create Training Facilities for Multiple Users
Q10062 - HOWTO: Create Training Facilities for Multiple Users

NOTE : You will need OPSSQL SuperUser priviledges to perform tasks described in this article.

  1. Let’s say you have 3 users that you want to create training databases for. For this example’s sake we’ll use the following users:
    John Doe
    Jane Doe
    Bob Smith
  2. Go to the OPSSQL cd. There is a folder called TutorV3
  3. Copy the TutorV3 folder to your local drive and make sure that the “Read-only” flag is unchecked. Remember where you put it.
  4. Fire up Ops Server Setup. You can use either executable (i.e the procedure is the same for oracle as well as mssql 2000)
  5. Login to your server.
  6. Once inside, click on the “import facility” tab.
  7. Browse for the mdb file by clicking the … button.  It’s going to be located wherever you put it in during step 3.
  8. Click Open and you’ll be back to :
  9. Fill out the unique identifier field and the facility name.
  10. Hit execute. Once the DB import is done, you’ll receive a confirmation.
  11. Close Ops Server Setup.
  12. Repeat steps 4-11 for Jane Doe and Bob Smith. The only change you need to make is in step 9, where you would choose the following


     for Jane Doe and Bob Smith respectively.
  13. Run OPSSQL Client. Select “John Doe Training Facility” in the facility field. When you click OK, you will see a dialog similar to this:
  14. Click Yes and follow instructions. The database upgrade process will upgrade all databases that need the upgrade, not just OPSTRAIN1. Once the process is done, you will see a confirmation message
  15. Run OPSSQL Client. When you now login to “John Doe Training Facility”, there should be no upgrade process requested.
  16. Go to User Setup
  17. It will ask you to confirm your password. Do that. You’ll arrive at this screen:
  18. Click the browse button (…) and  navigate to user John Doe. 
  19. If user doesn’t exit, create a new user with desired username.
  20. Make sure you give the user right to his desired database.
  21. Repeat steps 18-20 for Jane Doe and Bob Smith
  22. If you click the PRINT button now, you can output usernames and their respective passwords. This come in handy during upcoming steps.
  23. Close User Setup.
  24. In Main menu of OPSSQL, go to File/Open Facility. You will be back to OPS SQL login screen
  25. You want to login as JOHNDOE and pick “John Doe Training Facility” from facility list.
  26. Once inside OPSSQL, Go to File and check the Default Facility” menu item
  27. Repeat steps 24-26 for Jane Doe and Bob Smith.
Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?


Tell us why you rated the content this way. (optional)
Approved Comments...
No user comments available for this article.
Created on 10/29/2004 1:01 PM.
Last Modified on 9/18/2007 5:37 PM.
Last Modified by No Author Name Available!.
Article has been viewed 4081 times.
Rated 4 out of 10 based on 5 votes.
Print Article
Email Article