Ryan,
What would be much better is to create the single schema
and partition the tables so that each customer's data lands into it's own
partition. As for this other group, make some friends. It's a lot
easier to get your problems and concerns addressed if the people your talking to
are on a friendly basis with you. You can also bring up the problems of
scaling to your management in terms of dollars needed for additional servers,
memory, hard disk, and software. For some reason that is something pointy
headed managers seem to understand, especially when you start talking about
Oracle licenses at $40K per CPU.
Dick Goulet -----Original Message-----
From: Ryan [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 6:29 PM To: Multiple recipients of list ORACLE-L Subject: security without using different usernames 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
- 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
- Re: security without using different usernames Ryan