{"id":906,"date":"2014-04-01T17:17:46","date_gmt":"2014-04-01T15:17:46","guid":{"rendered":"http:\/\/clemente.pamplona.name\/dba\/?p=906"},"modified":"2014-04-01T17:18:40","modified_gmt":"2014-04-01T15:18:40","slug":"ejecutar-un-sql-como-otro-usuario","status":"publish","type":"post","link":"http:\/\/clemente.pamplona.name\/dba\/ejecutar-un-sql-como-otro-usuario\/","title":{"rendered":"Ejecutar un sql como otro usuario"},"content":{"rendered":"<p>Hoy vamos a volver a las entradas de dummies.<\/p>\n<p>Muchas veces, tenemos que ejecutar consultas desde sqlplus como un usuario de aplicaci\u00f3n del que desconocemos su contrase\u00f1a.<br \/>\nNosotros contamos con privilegios  de administrador, pero , lo que necesitamos es entrar con el usuario de aplicacion \u00abfotos\u00bb<\/p>\n<p>La soluci\u00f3n es extremadamente sencilla <\/p>\n<pre>\n<p>[oracle@server] [$sqlplus \"\/as sysdba\"<br \/>\nSQL*Plus: Release 11.2.0.2.0 Production on Mar Abr 1 21:15:45 2014<br \/>\nCopyright (c) 1982, 2011, Oracle.  All rights reserved.<br \/>\nConnected to:<br \/>\nOracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production<br \/>\nSQL> alter session set current_schema=FOTOS;<br \/>\nSession altered.<br \/>\nSQL><\/p>\n<pre>\n","protected":false},"excerpt":{"rendered":"<p>Hoy vamos a volver a las entradas de dummies. Muchas veces, tenemos que ejecutar consultas desde sqlplus como un usuario de aplicaci\u00f3n del que desconocemos su contrase\u00f1a. Nosotros contamos con privilegios de administrador, pero , lo que necesitamos es entrar &hellip; <a href=\"http:\/\/clemente.pamplona.name\/dba\/ejecutar-un-sql-como-otro-usuario\/\">Sigue leyendo <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9,13,7],"tags":[148,145,247],"class_list":["post-906","post","type-post","status-publish","format-standard","hentry","category-dummie","category-scripting","category-sqlplus","tag-alter-session","tag-like","tag-sqlplus"],"_links":{"self":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/906","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/comments?post=906"}],"version-history":[{"count":3,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/906\/revisions"}],"predecessor-version":[{"id":909,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/906\/revisions\/909"}],"wp:attachment":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/media?parent=906"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/categories?post=906"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/tags?post=906"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}