Setup User DB
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Setup User DB

  1. #1
    Join Date
    Mar 2001
    Posts
    109
    We are developing a web application and need to setup a database for each customer/user. Users can create their own attributes. Except those user defined attributes, the database schemas for each user are the same. We used to use MS SQL Server to create a separate database for each user.

    Now we are switching to Oracle. My question is: How can we setup user database in Oracle? It seems we can create a schema for each user, but I would like to know if there is any other choices. As the database schemas are the same except the user defined attributes, is it possible to use Virtual Private Database?

    One thing we need consider is that we need to backup/restore data/schema for single user.

    Thanks for any help.
    zm

  2. #2
    Join Date
    Nov 2000
    Posts
    344
    In Oracle, a schema and a user are the same thing. the only
    difference is conceptual.

    A schema becomes a schema (rather than just a user) when you build objects owned by the user. But really there is no difference. There is no setting or command you have to do to
    'turn a user into a schema'.

    With exports and imports you can backup and restore the schemas individually.

    I hope this answered your question.

    -John

  3. #3
    Join Date
    Mar 2001
    Posts
    109
    How about using Virtual Private Database?
    zm

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