Something to think about!!

From: Tom Zamani <tomz_at_redflex.com.au>
Date: Wed, 29 Dec 1999 12:37:28 +1100
Message-ID: <84bofn$3d0$1@perki.connect.com.au>

Here is the problem.
There are two users, u1,u2, u3
u1 owns all the stored programs, u2,u3 own only the data (tables, views etc) u1 has a package pac1 and this package has three procdures prc1, prc2,prc3

ARE WITH ME? using oracle 8i and invoker rigth, u2 can execute objects which are owned by u1 and data which u2 owns will get updated, this would be the same for u3.

now let say due to some changes in the bussiness roles, the procedure pac1.prc1 needs to be changed for u2, but it would stay the same for u3.

One way to get the system runing would be. copy the pac1 to u2, modify the prc2 and change the prc2 and prc3 so they would point to u1.pac1.prc2, u1.pac1.prc3

The other way is to us stand alone procedures and remove all the packages.

Can you think of a better way to do this.

The option one will increase the code maintenace. the second option is the last option.

Thanks in Advace
P.S. Happy new Year Received on Tue Dec 28 1999 - 19:37:28 CST