{"id":3,"date":"2006-07-19T00:44:00","date_gmt":"2006-07-19T04:44:00","guid":{"rendered":"http:\/\/www.benh.org\/techie\/2006\/07\/is-it-possible-to-rename-a-database-user-schema\/"},"modified":"2010-08-27T04:16:30","modified_gmt":"2010-08-27T09:16:30","slug":"rename-oracle-database-username","status":"publish","type":"post","link":"https:\/\/www.benh.org\/techblog\/2006\/07\/rename-oracle-database-username\/","title":{"rendered":"Rename Oracle database username"},"content":{"rendered":"<div style=\"margin-top: 0px; margin-bottom: 0px;\" class=\"sharethis-inline-share-buttons\" ><\/div><p><!--adsense#ads-->No, this is not available till now  in Oracle and has been noted down as a enhancement request.<br \/>\nStill here is a workaround way of doing that:<\/p>\n<ol class=\"bb-list\" style=\"list-style-type: circle;\">\n<li>Do a user-level export of user A<\/li>\n<li>create new user B<\/li>\n<li>import system\/manager from user=A to user=B<\/li>\n<li>drop user A<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>No, this is not available till now in Oracle and has been noted down as a enhancement request. Still here is a workaround way of doing that: Do a user-level export of user A create new user B import system\/manager from user=A to user=B drop user A<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[2],"tags":[63,41],"class_list":["post-3","post","type-post","status-publish","format-standard","hentry","category-database","tag-dba","tag-oracle"],"_links":{"self":[{"href":"https:\/\/www.benh.org\/techblog\/wp-json\/wp\/v2\/posts\/3","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benh.org\/techblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benh.org\/techblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benh.org\/techblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benh.org\/techblog\/wp-json\/wp\/v2\/comments?post=3"}],"version-history":[{"count":3,"href":"https:\/\/www.benh.org\/techblog\/wp-json\/wp\/v2\/posts\/3\/revisions"}],"predecessor-version":[{"id":179,"href":"https:\/\/www.benh.org\/techblog\/wp-json\/wp\/v2\/posts\/3\/revisions\/179"}],"wp:attachment":[{"href":"https:\/\/www.benh.org\/techblog\/wp-json\/wp\/v2\/media?parent=3"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benh.org\/techblog\/wp-json\/wp\/v2\/categories?post=3"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benh.org\/techblog\/wp-json\/wp\/v2\/tags?post=3"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}