Home » RDBMS Server » Security » password of users in 11g (11g)
password of users in 11g [message #510058] Thu, 02 June 2011 06:08 Go to next message
kapardi
Messages: 19
Registered: May 2011
Location: Pune
Junior Member

Hello michel

how to see password of users in 11g please suggest me query


Thanks and Regards

Kapardi

[Updated on: Thu, 02 June 2011 09:38] by Moderator

Report message to a moderator

Re:password of users in 11g [message #510059 is a reply to message #510058] Thu, 02 June 2011 06:15 Go to previous messageGo to next message
Littlefoot
Messages: 18822
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
select password
from over_his_shoulder
where he_does_not_see_me = 'TRUE'
  and he_types_too_fast = 'FALSE';


[EDIT] Ooops! I'm not Michel! Sorry, discard previous code.

[Updated on: Thu, 02 June 2011 09:38] by Moderator

Report message to a moderator

Re: password of users in 11g [message #510060 is a reply to message #510059] Thu, 02 June 2011 06:17 Go to previous messageGo to next message
cookiemonster
Messages: 10573
Registered: September 2008
Location: Rainy Manchester
Senior Member
Or to put it more obviously - you can't, by design.
A DBA can change a users password, but he can't see the current one.

[Updated on: Thu, 02 June 2011 09:38] by Moderator

Report message to a moderator

Re:password of users in 11g [message #510061 is a reply to message #510060] Thu, 02 June 2011 06:18 Go to previous messageGo to next message
cookiemonster
Messages: 10573
Registered: September 2008
Location: Rainy Manchester
Senior Member
And don't use Michel as a topic title.
This isn't askMichel and even if it was that title wouldn't be helpful.
Use a title that actually describes the problem.

[Updated on: Thu, 02 June 2011 09:39] by Moderator

Report message to a moderator

Re: password of users in 11g [message #510073 is a reply to message #510061] Thu, 02 June 2011 07:03 Go to previous messageGo to next message
Roachcoach
Messages: 1125
Registered: May 2010
Location: UK
Senior Member
This?

Sorry, had to, Littlefoots reply had me snorting with laughter in the officer (yeah...thanks for that Razz)

[Updated on: Thu, 02 June 2011 09:39] by Moderator

Report message to a moderator

Re:password of users in 11g [message #510074 is a reply to message #510073] Thu, 02 June 2011 07:06 Go to previous messageGo to next message
cookiemonster
Messages: 10573
Registered: September 2008
Location: Rainy Manchester
Senior Member
in the officer? which officer? Did they know you were doing that? Smile

[Updated on: Thu, 02 June 2011 09:39] by Moderator

Report message to a moderator

Re: password of users in 11g [message #510075 is a reply to message #510074] Thu, 02 June 2011 07:16 Go to previous messageGo to next message
Roachcoach
Messages: 1125
Registered: May 2010
Location: UK
Senior Member
must...not...post....filthy...image

[Updated on: Thu, 02 June 2011 09:39] by Moderator

Report message to a moderator

Re: password of users in 11g [message #510127 is a reply to message #510075] Thu, 02 June 2011 10:03 Go to previous messageGo to next message
ramoradba
Messages: 2451
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member


In Prior to Oracle 11g you can find Password hash values in DBA_USERS atleast (not the actual password).
But In Oracle 11g you cannot find password hash values in DBA_USERS.
SQL> create User a identified by "a";

User created.

SQL> create User b identified by "a";

User created.

SQL> select dbms_metadata.get_ddl('USER','A') from dual;

DBMS_METADATA.GET_DDL('USER','A')
--------------------------------------------------------------------------------

   CREATE USER "A" IDENTIFIED BY VALUES 'S:298EDEE1721E71B950D55CCB9ABA7EE5C596E
A6B0CCFF098E88889B98BD5;AFCC9478DFBF9029'
      DEFAULT TABLESPACE "USERS"
      TEMPORARY TABLESPACE "TEMP"



SQL> select dbms_metadata.get_ddl('USER','B') from dual;

DBMS_METADATA.GET_DDL('USER','B')
--------------------------------------------------------------------------------

   CREATE USER "B" IDENTIFIED BY VALUES 'S:25E85C1466288EE377681D131DF1920B33448
CD4108F8DDFC580A3315A39;9017AAA5BF2D9732'
      DEFAULT TABLESPACE "USERS"
      TEMPORARY TABLESPACE "TEMP"



SQL> select name, password, spare4 from sys.user$ where name ='A'
  2  ;

NAME                           PASSWORD
------------------------------ ------------------------------
SPARE4
--------------------------------------------------------------------------------
A                              AFCC9478DFBF9029
S:298EDEE1721E71B950D55CCB9ABA7EE5C596EA6B0CCFF098E88889B98BD5


SQL> select password,username from dba_users
  2  where length(username)=1;

PASSWORD                       USERNAME
------------------------------ ------------------------------
                               A
                               B

SQL>



Sriram


[Updated on: Thu, 02 June 2011 10:05]

Report message to a moderator

Re: password of users in 11g [message #510128 is a reply to message #510127] Thu, 02 June 2011 10:08 Go to previous messageGo to next message
BlackSwan
Messages: 21939
Registered: January 2009
Senior Member
SQL> desc user$
 Name					   Null?    Type
 ----------------------------------------- -------- ----------------------------
 USER#					   NOT NULL NUMBER
 NAME					   NOT NULL VARCHAR2(30)
 TYPE#					   NOT NULL NUMBER
 PASSWORD					    VARCHAR2(30)
 DATATS#				   NOT NULL NUMBER
 TEMPTS#				   NOT NULL NUMBER
 CTIME					   NOT NULL DATE
 PTIME						    DATE
 EXPTIME					    DATE
 LTIME						    DATE
 RESOURCE$				   NOT NULL NUMBER
 AUDIT$ 					    VARCHAR2(38)
 DEFROLE				   NOT NULL NUMBER
 DEFGRP#					    NUMBER
 DEFGRP_SEQ#					    NUMBER
 ASTATUS				   NOT NULL NUMBER
 LCOUNT 				   NOT NULL NUMBER
 DEFSCHCLASS					    VARCHAR2(30)
 EXT_USERNAME					    VARCHAR2(4000)
 SPARE1 					    NUMBER
 SPARE2 					    NUMBER
 SPARE3 					    NUMBER
 SPARE4 					    VARCHAR2(1000)
 SPARE5 					    VARCHAR2(1000)
 SPARE6 					    DATE
Re: password of users in 11g [message #510130 is a reply to message #510128] Thu, 02 June 2011 10:15 Go to previous messageGo to next message
ramoradba
Messages: 2451
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Yah ..Thats what I have shown.All the default '$' views/tables are dictionary objects Owned By sys.


Sriram

[Updated on: Thu, 02 June 2011 10:54]

Report message to a moderator

Re: password of users in 11g [message #510136 is a reply to message #510130] Thu, 02 June 2011 10:34 Go to previous messageGo to next message
Michel Cadot
Messages: 57606
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
All '$' views/tables are dictionary objects Owned By sys

Unless you create your own.

Regards
Michel
Re: password of users in 11g [message #510144 is a reply to message #510136] Thu, 02 June 2011 10:54 Go to previous message
ramoradba
Messages: 2451
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Yes.! Modified my message.

Sriram

[Updated on: Thu, 02 June 2011 12:56]

Report message to a moderator

Previous Topic: Oracle Audit Design
Next Topic: Read/write access
Goto Forum:
  


Current Time: Thu Apr 17 12:01:37 CDT 2014

Total time taken to generate the page: 0.17188 seconds