Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Database Users
Patrick,
Good Suggestions... basically I was thinking along the lines of number 2... my original idea was to use aliases... which gets kind of messy... actually changing to the user would be a better approach.
However, How can you physically partition the data BY USER? Logically, we can keep user information separate from one another, but can you do this so there is a physical seperation? Basically the customer just wants to be able to stick his own data into another database if need be. I was thinking the best way to do this would be to keep seperate users, and just run the Export utility to export a single user from our DB and to import it somewhere else.
In article <371F5845.4B94A0BB_at_lucent.com>,
Patrick Suppes <psuppes_at_lucent.com> wrote:
> Jeremy,
>
> Two possibilities to offer.
>
> 1) Will your client allow you to store all the Users data in a single schema,
> but partition the data by USER? This enables you to manage each users data
> independently, while still sharing a common set of tables, triggers, etc. I
> wouldn't call this a "decentralized" implementation, but it does allow the
user
> data to be stored separately. Is that what the client wants?
>
> 2) You could log into a common user, bang the table that maps unique id's to
> schemas, then do a dynamic change user (either disconnect/reconnect in earlier
> versions of Oracle, or alter user in 8.x).
>
> By changing to the "right" user, you can access the "right" set of tables by
> leaving off the schema name in the table access code (select xyz from table1,
for
> example), or by using a set of aliases. The aliases would be particularly
useful
> if your set of "users" is different than your set of "schemas".
>
> Patrick Suppes
>
> bjeremy_at_my-dejanews.com wrote:
>
> > Greetings,
> >
> > My problem is that I have to create a DB where all a Users data have to be
> > de-centralized and in a seperate schema. Basically, I have to create
> > Different users with the exact same schema and set of stored procedures
> > (don't ask... its a requirement).
> >
> > <snip>
> >
> > regards,
> >
> > jeremy
> >
> > -----------== Posted via Deja News, The Discussion Network ==----------
> > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
>
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Apr 23 1999 - 14:55:05 CDT