I know this is terrible design, but the GUI was
created by a software engineering group that is seperate from the database
group. Its not scalable. So Im trying to come up with a more scalable method. I
have no power to change their gui. It rides on the database. I have to live with
it. This is not a high enough transaction database to warrant seperate
instances.
We have a variety of customers. Each of them has
their own versions of data. However, the schema is exactly the same. These
tables can get huge, so we dont want to throw them all into the same
schema.
Right now, due to the fact that the GUI has a
series of logins that are the same across clients, each client has its own
instance. This isnt very scalable as we get more business. We have to create
another instance and ingest data to it.
Id like to find a way to get all the clients in the
same instance with just different schemas and tablespaces. One thing I may have
control over would be to slightly rename the executable. If you check v$session,
in a client-server application the name of the product connecting to the
database is recording. I can handle security based off of that.
My question is what would be the best way? Cant do
synonyms for this since its the same login. I think I saw somewhere that there
is a session based 'set' command where you can say use this schema. I think it
was on asktom and in reference to a question about public synonyms. I cant find
it. Anyone know it?
Also is it viable to base a context off of what is
in v$sesion with a logon trigger? How would I 'redirect' all queries to a
specific schema?
To stress, I cant change the application. Different
group with different skillsets. Any suggestions?
|
Title: RE: upgrade to AIX 5
- RE: security without using different usernames Ryan
- RE: security without using different usernames Goulet, Dick
- Re: security without using different usernames Tanel Poder
- Re: security without using different usernames Ryan
- Re: security without using different usernames Ryan
- Re: security without using different usernames JApplewhite
- Re: security without using different usernames AK
- RE: security without using different usernames Pardee, Roy E
- Re: security without using different usernames JApplewhite
- RE: security without using different usernames Rudy Zung
- Re: security without using different usernames Ryan