Home » RDBMS Server » Security » Manage Large Number of Users (11g, Linux)
Manage Large Number of Users [message #425981] Tue, 13 October 2009 08:52 Go to next message
Messages: 97
Registered: June 2005
Dear All:

We are getting a Pre Prod database for which we may have to create around 1200 users who will have account inside the database. Here are my concerns:

1.What is the best way for the users to connect to the database? We traditionally used Tnsnames.ora file but it would be cumbersome to go with that with so many users. We heard about Active Directory which could help users to connect to the database. Is that a proven way to go and how to implement it ?

2.What are the parameters we need to change/modify in our init/spfile to accomodate high number of users ? We are and will be using the dedicated connections. To me it seems that we need to modify the #process parameter to a number higher than >1200 at least. The memory management we set automatic as both SGA and PGA managed by Oracle. We already designated a large chunk of memory(8GB) to Oracle for doing the both SGA/PGA management for us.

3.What other issues we need to be concerned for database when so many users will be logging on to the database ? Most of these users will not use any storage to create objects.

Any help, advise, suggestion will be highly appreciated.

Re: Manage Large Number of Users [message #425988 is a reply to message #425981] Tue, 13 October 2009 09:51 Go to previous messageGo to next message
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
I have NEVER see where actual end users each has their own Oracle schema.

In every case only a handful of Oracle schemas exist to own & support an application.

The application itself manages its users internally.

Perhaps you should reconsider how security is to be managed.
Re: Manage Large Number of Users [message #427446 is a reply to message #425981] Thu, 22 October 2009 12:07 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10706
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Re: Manage Large Number of Users [message #427450 is a reply to message #425981] Thu, 22 October 2009 12:33 Go to previous message
Michel Cadot
Messages: 68341
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Same question and several useful answers at:

Previous Topic: privilege for Alter fixed_date parameter
Next Topic: user searching
Goto Forum:

Current Time: Sat Jan 28 19:45:02 CST 2023