| ...application connectivity with multiple users. [message #176728] |
Fri, 09 June 2006 05:43 |
orcl_dba
Messages: 84
Registered: March 2005
|
Member |
|
|
Hi.
An application developed in Oracle Forms 6i, which contains a history module.
History module basically captures the old./ new values after updates on a few tables, and write them in another table,
with username and date, so that management knows who updates and when.
All the users are Database users.
Now the application is going to be shifted to web using PHP..
The web development style is that you have a single user which connects with databaase , and all other users are application users , which are authenticated from a user table.
suppose your name is ABC and ur pasword is B,
this info will be wriiten in a table from where you are authenticated, but connection to database may be made using
user FFF identified by G..
Is it possible that we create actual DB users instead of application users, so that one can kill session if required for a particular user.
Also may i know what is the common style all over the world , where Oracle Databae is running a web application.
I mean which one is the better design and how to achieve that.
i hope i have made my question clear.
Is it good to have application level users, and 1 user for db,
or to have all db users, and how oracle manages the session.
Thanks alot
Regards
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
