{"id":20235,"date":"2025-07-14T17:30:28","date_gmt":"2025-07-14T23:30:28","guid":{"rendered":"https:\/\/sada.services\/?p=20235"},"modified":"2025-07-14T17:30:28","modified_gmt":"2025-07-14T23:30:28","slug":"infra-oracle-crear-usuario","status":"publish","type":"post","link":"https:\/\/sada.services\/?p=20235","title":{"rendered":"infra-Oracle-Crear Usuario"},"content":{"rendered":"\n<ul class=\"wp-block-list\">\n<li>para crear un usuario de oracle y darle permisos de consulta sobre tablas <\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">paso1: Crear usuario<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>en la BD de banner con sys<\/li>\n\n\n\n<li>creamos el usuario<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>--****************************************************\n-- BANNER9\n--****************************************************\nDROP USER PORTAL_INV;\n\n--+++++++++++++++++++++++++++++++++++++++\n-- Creaci\u00f3n de usuario\n--+++++++++++++++++++++++++++++++++++++++\nCREATE USER PORTAL_INV\n  IDENTIFIED BY \"PortalInv2025.\"\n  DEFAULT TABLESPACE users\n  TEMPORARY TABLESPACE temp\n  QUOTA UNLIMITED ON users;\n  \n  \n--+++++++++++++++++++++++++++++++++++++++\n-- Permiso de crear sesiones\n--+++++++++++++++++++++++++++++++++++++++\nGRANT CREATE SESSION TO PORTAL_INV;<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ahora para saber a que esquema le pertenece la tabla ejecutamos <\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT owner\nFROM all_tables\nWHERE table_name = 'PERSONA_OFFICE';<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>paso1: Crear usuario<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-20235","post","type-post","status-publish","format-standard","hentry","category-sin-categoria"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/20235","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=20235"}],"version-history":[{"count":1,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/20235\/revisions"}],"predecessor-version":[{"id":20236,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/20235\/revisions\/20236"}],"wp:attachment":[{"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=20235"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=20235"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=20235"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}