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
rkl1
Messages: 97
Registered: June 2005
Member
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.

Thanks.
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
BlackSwan
Messages: 22901
Registered: January 2009
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: 10628
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
try
http://www.shutdownabort.com/tnsmanager/
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: 59414
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Same question and several useful answers at:
http://www.dba-village.com/dba/village/dvp_forum.OpenThread?ThreadIdA=38041&SkipA=0

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


Current Time: Tue Oct 21 15:33:39 CDT 2014

Total time taken to generate the page: 0.07511 seconds