Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Difrent users using the exact same tables
Hi!
How do I copy everything from one user to a new user?
For the curious:
Now afer 3 monuths finaly my system for handling questions and aserws
conserning animal science are finished. In the system, the user can logg
in and search aswell as asking questions wich are aserwed by a panel of
experts. It is a system that consist of a Sun Ultra 10, Apache
webserver, JAVA-sevlets, JDBC and Oracle 8.
The JAVA program is designed so that a special sevlet handles all user in and output, and other JAVA objects prosess the data and talks to the database. Those objects talking to the database is common objects that can be used along with other "Actionhadler-servlets" to create a new instance of the system wich could handle questions conserning something else.
But to keep the pressent system from a new one, I have designed the system so that the actionhandler-servlet knows oabout wich system it belongs to. It passes a parameter wich tells the common object for databastransactions wich username and password to logg in with.
My ide is to create a new user in the database for each new "question&anserws-database". This new user must have all the tables (but not its contents) and all the stored funtions. Also it is importaint that a change in the database design effects all the users.
So what do you think about this? I am a beginner som I would realy appreciate all comments!
/ Mattias Received on Sat Sep 12 1998 - 14:26:55 CDT