Home » RDBMS Server » Server Administration » same user connecting from 10 machines
same user connecting from 10 machines [message #219603] Thu, 15 February 2007 02:07 Go to next message
Messages: 356
Registered: March 2005
Senior Member
I am not competent enough in server administration. Can u please tell me about the scenario.

If there is one database on server. and one schema i.e HR (apart from other system schemas). I am using 10 different machines to access the same database at the same time updating, deleting , inserting into the objects. All the processes take place at the same time.

Is this OK to user the single user from all the 10 machines?

I should create 10 different users, grant privs on objects to them, create synonyms there for all objects. And should connect as different user on differnt machines?

I m seeing it in terms of performance, speed and security.

Re: same user connecting from 10 machines [message #219606 is a reply to message #219603] Thu, 15 February 2007 02:21 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member


It is not matter you connect with different user or some user. all depand on SESSION.
every connect count is session.

you should create separate user and grant privs with there minimum requirements.

Re: same user connecting from 10 machines [message #219867 is a reply to message #219606] Fri, 16 February 2007 08:06 Go to previous message
Messages: 3202
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
In case of our databases we usually just have different oracle user if we need different access rights for different applications.

E.g. one user with DBA rights for administration, one user for the accounting application, and one read-only user for transfering data to some external program.

Note : One thing that comes in handy sometimes is that you can also get the logged in OS user :

select sys_context('USERENV', 'OS_USER') from dual;

So when you want to trace updates, etc in you application you can log the OSuser that did it, even though everybody used the same Oracle user.
Previous Topic: Migration from MSSQL SERVER 2000 to ORACLE 10G
Next Topic: How complex is Oracle 10g Server Administration
Goto Forum:

Current Time: Thu Aug 24 03:55:19 CDT 2017

Total time taken to generate the page: 0.14389 seconds