{"id":14740,"date":"2020-01-15T06:12:30","date_gmt":"2020-01-15T06:12:30","guid":{"rendered":"https:\/\/dbtut.com\/?p=14740"},"modified":"2020-01-15T06:12:32","modified_gmt":"2020-01-15T06:12:32","slug":"oracle-user-operations","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2020\/01\/15\/oracle-user-operations\/","title":{"rendered":"Oracle User Operations"},"content":{"rendered":"<p>This article contains information about Oracle User Operations like creating a new Oracle user, authorizing, changing password and dropping Oracle User.<\/p>\n<h4>Create Oracle User<\/h4>\n<p>CREATE USER is used to create the user for the Oracle database.<\/p>\n<p>The keywords to be used during user creation are as follows.<\/p>\n<pre class=\"lang:default decode:true \">CREATE USER user_name \n  IDENTIFIED { BY password\n             | EXTERNALLY [ AS 'certificate_DN' ]\n             | GLOBALLY [ AS '[ directory_DN ]' ]\n             }\n  [ DEFAULT TABLESPACE tablespace\n  | TEMPORARY TABLESPACE\n       { tablespace | tablespace_group }\n  | QUOTA integer [ K | M | G | T | P | E ]\n        | UNLIMITED }\n        ON tablespace\n    [ QUOTA integer [ K | M | G | T | P | E ]\n        | UNLIMITED }\n            ON tablespace\n    ]\n  | PROFILE profile_name\n  | PASSWORD EXPIRE\n  | ACCOUNT { LOCK | UNLOCK }\n     [ DEFAULT TABLESPACE tablespace\n     | TEMPORARY TABLESPACE\n         { tablespace | tablespace_group }\n     | QUOTA integer [ K | M | G | T | P | E ]\n           | UNLIMITED }\n           ON tablespace\n       [ QUOTA integer [ K | M | G | T | P | E ]\n           | UNLIMITED }\n           ON tablespace\n        ]\n     | PROFILE profile\n     | PASSWORD EXPIRE\n     | ACCOUNT { LOCK | UNLOCK } ]\n     ] ;<\/pre>\n<p>We can create user as follows using only username and password.<\/p>\n<pre class=\"lang:default decode:true \">CREATE USER Your_User_Name IDENTIFIED BY Your_User_Password;<\/pre>\n<p>After the command is executed, it will create the user according to the value specified with Your_User_Name and Your_User_Password.<\/p>\n<h4>Change Oracle User Password<\/h4>\n<p>ALTER USER keywords are used to change the user&#8217;s password.<\/p>\n<pre class=\"lang:default decode:true \">ALTER USER Your_User_Name IDENTIFIED by New_Password;<\/pre>\n<h4>Grant Permission To Oracle User<\/h4>\n<p>The GRANT keyword is used to grant permission to Oracle user.<\/p>\n<pre class=\"lang:default decode:true\">GRANT Permission1,Permission2,Permission3 TO Your_User_Name;<\/pre>\n<p>You can grant permissions like CREATE SESSION, CREATE TABLE, CREATE SEQUENCE, CREATE VIEW, CREATE PRODECURE, SELECT, INSERT, UPDATE or custom table and column based.<\/p>\n<h4>Oracle grant column privileges<\/h4>\n<pre class=\"lang:default decode:true\">GRANT UPDATE(column1, column2) ON Your_Table_Name TO Your_User_Name;<\/pre>\n<h4>Oracle grant all privileges<\/h4>\n<p>The ALL PRIVILEGES value is used to grant all privileges to a user.<\/p>\n<pre class=\"lang:default decode:true \">GRANT ALL PRIVILEGES TO Your_User_Name;<\/pre>\n<h4>Revoke Permission From Oracle User<\/h4>\n<p>The REVOKE keyword is used to revoke user privileges.<\/p>\n<pre class=\"lang:default decode:true\">REVOKE Permission1,Permission2,Permission3 TO Your_User_Name;<\/pre>\n<h4>Lock and Unlock Oracle User<\/h4>\n<p>In Oracle user processes, the user can be locked. You can change the parameters that cause the user to crash in Oracle Profiles. You can find more information in the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/06\/19\/how-to-create-oracle-profiles\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Create Oracle Profiles<\/a>&#8220;. You may also be interested in the following articles.<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/06\/14\/how-to-change-user-profile-on-oracle\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Change User Profile On Oracle<\/a>&#8220;,<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/02\/05\/how-to-keep-same-password-for-oracle-user-when-its-expiredgrace-state\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Keep Same Password For Oracle User When Its EXPIRED(GRACE) State<\/a>&#8220;,<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/01\/23\/how-to-set-password-policy-in-oracle\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Set Password Policy in Oracle<\/a>&#8220;,<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/10\/17\/oracle-password-expired-error\/\" target=\"_blank\" rel=\"noopener noreferrer\">Oracle Password Expired Error<\/a>&#8220;,<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/07\/28\/profile-password-verify-function-issuefrom-root\/\" target=\"_blank\" rel=\"noopener noreferrer\">Profile password verify function issue(FROM ROOT)<\/a>&#8221;<\/p>\n<p>The ALTER USER keyword is used for user locking.<\/p>\n<pre class=\"lang:default decode:true\">ALTER USER Your_User_Name ACCOUNT LOCK;<\/pre>\n<p>Have a good day.<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_14740\" class=\"pvc_stats all  \" data-element-id=\"14740\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>This article contains information about Oracle User Operations like creating a new Oracle user, authorizing, changing password and dropping Oracle User. Create Oracle User CREATE USER is used to create the user for the Oracle database. The keywords to be used during user creation are as follows. CREATE USER user_name IDENTIFIED { BY password | &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_14740\" class=\"pvc_stats all  \" data-element-id=\"14740\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":485,"featured_media":14741,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[95,7843,7841,7842,7850,7846,7844,7847,7863,7845,7865,7848,7852,7849,7854,7853,7856,7857,7851,7855,7866,7864,7860,7861,7858,7859,7862,2425,7867],"class_list":["post-14740","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-change-oracle-password","tag-change-oracle-user-password","tag-create-oracle-user","tag-create-oracle-user-example","tag-grant-column-privilege-in-oracle","tag-grant-permission-oracle","tag-grant-permission-to-oracle-user","tag-grant-privileges-oracle","tag-lock-oracle-user","tag-oracle-authorization","tag-oracle-expired-user-activation","tag-oracle-grant-all-privileges-on-schema","tag-oracle-grant-column-level-access","tag-oracle-grant-column-privileges","tag-oracle-grant-column-select","tag-oracle-grant-column-update","tag-oracle-grant-grant-column","tag-oracle-grant-grant-columns","tag-oracle-grant-select-column-privileges","tag-oracle-grant-update-column-only","tag-oracle-lock-user-command","tag-oracle-lock-users","tag-revoke-all-privileges-from-user-oracle","tag-revoke-dba-privileges-from-user-oracle","tag-revoke-permission-from-oracle-user","tag-revoke-privilege-from-user-oracle","tag-revoke-privileges-from-user-oracle","tag-unlock-oracle-user","tag-unlock-oracle-user-command"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Oracle User Operations - Database Tutorials<\/title>\n<meta name=\"description\" content=\"Oracle User Operations\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2020\/01\/15\/oracle-user-operations\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle User Operations - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Oracle User Operations\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2020\/01\/15\/oracle-user-operations\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2020-01-15T06:12:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-01-15T06:12:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-12.png\" \/>\n\t<meta property=\"og:image:width\" content=\"532\" \/>\n\t<meta property=\"og:image:height\" content=\"300\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Yusuf SEZER\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Yusuf SEZER\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/15\/oracle-user-operations\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/15\/oracle-user-operations\/\"},\"author\":{\"name\":\"Yusuf SEZER\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/be8bf54494b6a89e626cbed2c940599a\"},\"headline\":\"Oracle User Operations\",\"datePublished\":\"2020-01-15T06:12:30+00:00\",\"dateModified\":\"2020-01-15T06:12:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/15\/oracle-user-operations\/\"},\"wordCount\":274,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/15\/oracle-user-operations\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-12.png\",\"keywords\":[\"Change Oracle Password\",\"Change Oracle User Password\",\"Create Oracle User\",\"create oracle user example\",\"grant column privilege in oracle\",\"Grant Permission Oracle\",\"Grant Permission To Oracle User\",\"grant privileges oracle\",\"lock oracle user\",\"Oracle Authorization\",\"oracle expired user activation\",\"oracle grant all privileges on schema\",\"oracle grant column level access\",\"oracle grant column privileges\",\"oracle grant column select\",\"oracle grant column update\",\"oracle grant grant column\",\"oracle grant grant columns\",\"oracle grant select column privileges\",\"oracle grant update column only\",\"oracle lock user command\",\"oracle lock users\",\"revoke all privileges from user oracle\",\"revoke dba privileges from user oracle\",\"Revoke Permission From Oracle User\",\"revoke privilege from user oracle\",\"revoke privileges from user oracle\",\"unlock oracle user\",\"unlock oracle user command\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/01\/15\/oracle-user-operations\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/15\/oracle-user-operations\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/15\/oracle-user-operations\/\",\"name\":\"Oracle User Operations - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/15\/oracle-user-operations\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/15\/oracle-user-operations\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-12.png\",\"datePublished\":\"2020-01-15T06:12:30+00:00\",\"dateModified\":\"2020-01-15T06:12:32+00:00\",\"description\":\"Oracle User Operations\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/15\/oracle-user-operations\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/01\/15\/oracle-user-operations\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/15\/oracle-user-operations\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-12.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-12.png\",\"width\":532,\"height\":300},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/15\/oracle-user-operations\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle User Operations\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/be8bf54494b6a89e626cbed2c940599a\",\"name\":\"Yusuf SEZER\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/19675b3db2d4ce370af047187123e2055a2b254ede3f0e7d9bc934da478146f7?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/19675b3db2d4ce370af047187123e2055a2b254ede3f0e7d9bc934da478146f7?s=96&d=mm&r=g\",\"caption\":\"Yusuf SEZER\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/yusufsezer\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle User Operations - Database Tutorials","description":"Oracle User Operations","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2020\/01\/15\/oracle-user-operations\/","og_locale":"en_US","og_type":"article","og_title":"Oracle User Operations - Database Tutorials","og_description":"Oracle User Operations","og_url":"https:\/\/dbtut.com\/index.php\/2020\/01\/15\/oracle-user-operations\/","og_site_name":"Database Tutorials","article_published_time":"2020-01-15T06:12:30+00:00","article_modified_time":"2020-01-15T06:12:32+00:00","og_image":[{"width":532,"height":300,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-12.png","type":"image\/png"}],"author":"Yusuf SEZER","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Yusuf SEZER","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/15\/oracle-user-operations\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/15\/oracle-user-operations\/"},"author":{"name":"Yusuf SEZER","@id":"https:\/\/dbtut.com\/#\/schema\/person\/be8bf54494b6a89e626cbed2c940599a"},"headline":"Oracle User Operations","datePublished":"2020-01-15T06:12:30+00:00","dateModified":"2020-01-15T06:12:32+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/15\/oracle-user-operations\/"},"wordCount":274,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/15\/oracle-user-operations\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-12.png","keywords":["Change Oracle Password","Change Oracle User Password","Create Oracle User","create oracle user example","grant column privilege in oracle","Grant Permission Oracle","Grant Permission To Oracle User","grant privileges oracle","lock oracle user","Oracle Authorization","oracle expired user activation","oracle grant all privileges on schema","oracle grant column level access","oracle grant column privileges","oracle grant column select","oracle grant column update","oracle grant grant column","oracle grant grant columns","oracle grant select column privileges","oracle grant update column only","oracle lock user command","oracle lock users","revoke all privileges from user oracle","revoke dba privileges from user oracle","Revoke Permission From Oracle User","revoke privilege from user oracle","revoke privileges from user oracle","unlock oracle user","unlock oracle user command"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2020\/01\/15\/oracle-user-operations\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/15\/oracle-user-operations\/","url":"https:\/\/dbtut.com\/index.php\/2020\/01\/15\/oracle-user-operations\/","name":"Oracle User Operations - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/15\/oracle-user-operations\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/15\/oracle-user-operations\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-12.png","datePublished":"2020-01-15T06:12:30+00:00","dateModified":"2020-01-15T06:12:32+00:00","description":"Oracle User Operations","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/15\/oracle-user-operations\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2020\/01\/15\/oracle-user-operations\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/15\/oracle-user-operations\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-12.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-12.png","width":532,"height":300},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/15\/oracle-user-operations\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Oracle User Operations"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/be8bf54494b6a89e626cbed2c940599a","name":"Yusuf SEZER","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/19675b3db2d4ce370af047187123e2055a2b254ede3f0e7d9bc934da478146f7?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/19675b3db2d4ce370af047187123e2055a2b254ede3f0e7d9bc934da478146f7?s=96&d=mm&r=g","caption":"Yusuf SEZER"},"url":"https:\/\/dbtut.com\/index.php\/author\/yusufsezer\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/14740","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/485"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=14740"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/14740\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/14741"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=14740"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=14740"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=14740"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}