{"id":2255,"date":"2012-06-06T22:14:09","date_gmt":"2012-06-07T03:14:09","guid":{"rendered":"http:\/\/appcrawler.com\/wordpress\/?p=2255"},"modified":"2012-06-06T22:14:09","modified_gmt":"2012-06-07T03:14:09","slug":"passwords-in-11-2-0","status":"publish","type":"post","link":"http:\/\/appcrawler.com\/wordpress\/2012\/06\/06\/passwords-in-11-2-0\/","title":{"rendered":"Passwords in 11.2.0"},"content":{"rendered":"<p>Oracle removed the password from the DBA_USERS view in 11g, but apparently it can be fetched from the USER$ table (to which no one should normally have access) by concatenating SPARE4 and the PASSWORD column with a semicolon between the two.<\/p>\n<pre lang=\"sql\">\r\nSQL> select dbms_metadata.get_ddl('USER','ATL') from dual;\r\n\r\nDBMS_METADATA.GET_DDL('USER','ATL')\r\n--------------------------------------------------------------------------------\r\n\r\n   CREATE USER \"ATL\" IDENTIFIED BY VALUES 'S:48F8D7A67379F9FC225FD2A621950D23EDE\r\n2435C789C07B8C4A4E294B78B;6B15AF8BDEABA33B'\r\n      DEFAULT TABLESPACE \"USERS\"\r\n      TEMPORARY TABLESPACE \"TEMP\"\r\n\r\n\r\nSQL> select spare4 from user$ where name = 'ATL';\r\n\r\nSPARE4\r\n--------------------------------------------------------------------------------\r\nS:48F8D7A67379F9FC225FD2A621950D23EDE2435C789C07B8C4A4E294B78B\r\n\r\nSQL> select password from user$ where name = 'ATL';\r\n\r\nPASSWORD\r\n------------------------------\r\n6B15AF8BDEABA33B\r\n\r\nSQL>\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Oracle removed the password from the DBA_USERS view in 11g, but apparently it can be fetched from the USER$ table (to which no one should normally have access) by concatenating SPARE4 and the PASSWORD column with a semicolon between the&hellip;<\/p>\n<p class=\"more-link-p\"><a class=\"more-link\" href=\"http:\/\/appcrawler.com\/wordpress\/2012\/06\/06\/passwords-in-11-2-0\/\">Read more &rarr;<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"footnotes":""},"categories":[19,22],"tags":[],"_links":{"self":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/2255"}],"collection":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/comments?post=2255"}],"version-history":[{"count":2,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/2255\/revisions"}],"predecessor-version":[{"id":2257,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/2255\/revisions\/2257"}],"wp:attachment":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/media?parent=2255"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/categories?post=2255"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/tags?post=2255"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}