Home » SQL & PL/SQL » SQL & PL/SQL » how to know no of users in sql prompt (sql)
how to know no of users in sql prompt [message #426627] Sat, 17 October 2009 07:45 Go to next message
sivaora
Messages: 119
Registered: October 2009
Location: Hyderabad
Senior Member
how to know the number of users created in sql prompt in oracle 9i.
is there any system table to know the username and password for all users.

if any one knows , please reply me soon.
thanks in advance.

Re: how to know no of users in sql prompt [message #426628 is a reply to message #426627] Sat, 17 October 2009 07:52 Go to previous messageGo to next message
pablolee
Messages: 2813
Registered: May 2007
Location: Scotland
Senior Member
Look at the all_users table. You cannot however, find the password.
Re: how to know no of users in sql prompt [message #426629 is a reply to message #426627] Sat, 17 October 2009 08:34 Go to previous messageGo to next message
balakrishnay
Messages: 54
Registered: September 2009
Location: Pune
Member
Hi,

select count(1) from dba_users;

Password will be in encrypted format 

SQL> select username,password from dba_users;

USERNAME                       PASSWORD
------------------------------ ------------------------------
MGMT_VIEW                      F25A184809D6458D
SYS                            739860B6A65CA368
SYSTEM                         7535E977467C25B7
DBSNMP                         23ABB433202848B7
SYSMAN                         66514ACB12E0A2A9
SCOTT                          F894844C34402B67
OUTLN                          4A3BA55E08595C81
MDSYS                          72979A94BAD2AF80

You can crack the password follow this URL:- 

http://www.petefinnigan.com/oracle_password_cracker.htm



Regards

Bala

Re: how to know no of users in sql prompt [message #426632 is a reply to message #426629] Sat, 17 October 2009 09:18 Go to previous messageGo to next message
Michel Cadot
Messages: 63810
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Password is not encrypted it is hashed and there is no cracker only tools that try many and many possible passwords and check if the hashed string is the same one.
So if your password is strong enough there is no chance someone knows it during his life.

Regards
Michel

[Updated on: Sat, 17 October 2009 09:18]

Report message to a moderator

Re: how to know no of users in sql prompt [message #426635 is a reply to message #426627] Sat, 17 October 2009 09:38 Go to previous messageGo to next message
balakrishnay
Messages: 54
Registered: September 2009
Location: Pune
Member

Hi Michel,

I just wanted to know for my knowledge what is the difference between encrypted & hashed as per your reply?.

Regards

Bala
Re: how to know no of users in sql prompt [message #426638 is a reply to message #426635] Sat, 17 October 2009 10:22 Go to previous messageGo to next message
Michel Cadot
Messages: 63810
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Hashed: One way; you can't reverse; several input strings can result to a same hashed value, this is called a collision. Think it as mashed potatoes; you can't go from mashed potatoes to the original ones and different potatoes can lead to the same heap of mashed potatoes. Exemple MD5 is a hashing algorithm.

Encrypted: Two ways; you can reverse it and retrieve the input value from the result (if you know all the encrypting parameters). Exemple AES is an encryption algorithm.

Regards
Michel

[Updated on: Sat, 17 October 2009 10:22]

Report message to a moderator

Re: how to know no of users in sql prompt [message #426641 is a reply to message #426627] Sat, 17 October 2009 11:15 Go to previous messageGo to next message
balakrishnay
Messages: 54
Registered: September 2009
Location: Pune
Member

Thanks Michel !! Smile. I will introgate into this a bit .

Regards

Bala
Re: how to know no of users in sql prompt [message #426692 is a reply to message #426632] Mon, 19 October 2009 00:46 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Michel Cadot wrote on Sat, 17 October 2009 16:18
Password is not encrypted it is hashed and there is no cracker only tools that try many and many possible passwords and check if the hashed string is the same one.
So if your password is strong enough there is no chance someone knows it during his life.

Regards
Michel

Unfortunately, you cannot tell. Since the password is hashed, a very simple password could hash to the same outcome.
However, in general you are correct. If people would use brute-force methods, simple passwords would stand a bigger chance of being retrieved than complicated ones.
Re: how to know no of users in sql prompt [message #426764 is a reply to message #426641] Mon, 19 October 2009 08:21 Go to previous messageGo to next message
joy_division
Messages: 4617
Registered: February 2005
Location: East Coast USA
Senior Member
balakrishnay wrote on Sat, 17 October 2009 12:15

Thanks Michel !! Smile. I will introgate into this a bit .


Is "introgate" a misspelling? What word is it supposed to be?
Re: how to know no of users in sql prompt [message #427043 is a reply to message #426629] Tue, 20 October 2009 14:21 Go to previous message
sivaora
Messages: 119
Registered: October 2009
Location: Hyderabad
Senior Member
thanks for all.
Previous Topic: Error while creating view in oracle 11g
Next Topic: Report not formating columns properly
Goto Forum:
  


Current Time: Thu Sep 29 15:59:23 CDT 2016

Total time taken to generate the page: 0.14494 seconds