Re: VIRTUAL PRIVATE DATABASE

zamba wrote:
> Hi. I work with a software where all the table in its database model
> doesn t have the company identifier. Well i need to convert this
> application for use into a multi-company enviroment, it means that in
> one schema i could store data for several company. Some people told me
> to use VIRTUAL PRIVATE DATABASE, but i don't have idea if this could
> resolve my problem, i mean if this works if i don't have the "company"
> identifier in all the tables.. Pls i will accept recomendations about
> it.
> Sorry about my english.
>
> Thanks

For some thoughts about this, see the recent thread in this group "VPD vs Multiple Schemas."

It may depend on how many tables and how much data and how many dml statements you have. You could perhaps write a program to make "create table as select" statements for all your tables, with an additional company field. Changing the data is usually relatively straightforward, modifying code can be a lot of work.

When you are done, you will inevitably have someone say, "A third of this company is being sold off, can you split it into two companies?"

Since I normally work on customizing commercially available systems, I see a lot of attributes based on company or division. There usually winds up being a number of flags to control how things work based on these attributes. This is a good thing, because it means less code modification just because different business entities have different priorities and processes. Then again, some people customizing the systems don't know about these things or have myths and legends about how they work, making coding more difficult.

Everything is a tossup.

jg

--
@home.com is bogus.
Atom injection:  http://www.net-security.org/article.php?id=949