Home » RDBMS Server » Server Administration » User Creation (Oracle, 9i, XP)
User Creation [message #326803] Thu, 12 June 2008 11:34 Go to next message
aslamsadia
Messages: 19
Registered: December 2006
Junior Member
How many user account can be created in one database?
Re: User Creation [message #326805 is a reply to message #326803] Thu, 12 June 2008 11:37 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
aslamsadia wrote on Thu, 12 June 2008 09:34
How many user account can be created in one database?

many or enough depending upon externalities
On my primary Production server:

SQL> select count(*) from dba_users;

  COUNT(*)
----------
        28



Keep in mind that number of database users do NOT necessarily match the number of application users.

My application supports tens of thousands application users.

[Updated on: Thu, 12 June 2008 11:39] by Moderator

Report message to a moderator

Re: User Creation [message #326813 is a reply to message #326803] Thu, 12 June 2008 12:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As many as you want.

Regards
Michel
Re: User Creation [message #326894 is a reply to message #326813] Fri, 13 June 2008 00:21 Go to previous messageGo to next message
aslamsadia
Messages: 19
Registered: December 2006
Junior Member
Thanks for info. about User Creation. Smile
Re: User Creation [message #327043 is a reply to message #326813] Fri, 13 June 2008 09:21 Go to previous messageGo to next message
srivijay
Messages: 3
Registered: June 2008
Junior Member
As many as you want.
Re: User Creation [message #327052 is a reply to message #327043] Fri, 13 June 2008 10:00 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Are you testing copy and paste other's answer?
Is this case you failed, you missed:

Regards
Michel
Previous Topic: ora-01034 ORACLE not available (merged)
Next Topic: 10G AND D2K CONNECTION PROBLEM
Goto Forum:
  


Current Time: Thu Dec 08 14:36:12 CST 2016

Total time taken to generate the page: 0.06031 seconds