Re: Database Users

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
Received on Thu Apr 22 1999 - 12:11:33 CDT