oracle database jdbc issue-- multiple users vs single user -
03-14-2005
, 07:15 PM
Hi Oracle/JDBC guru,
What is the difference for java/database project by using multiple
users vs. single user?
Our applications using oracle 9i database and the DBA created multiple
users to manage different sets of tables. But all users have to grant
insert, update, delete privileges to each other.
There is an overhead on DBA task obviously.
My question is does the multiple users mechanism has any benefits on
JDBC part of the application? such as better connections? (There is a
connection pool) or something else? |